have a formula:
=ISNUMBER(MATCH(A2:A779;'PARTS SHEET'.A1:A25200;0))
works and returns a true or false response. i would like to set a style into my formular to be green true or red for false
[Solved] Question on qualifiers
[Solved] Question on qualifiers
Last edited by macjohn79 on Fri Apr 26, 2019 2:13 pm, edited 1 time in total.
Open office 4.1 / windows 7
Re: question on qualifiers
You can do this through the menu Format -> Conditional formatting. Use the value 1 to match TRUE and 0 to match FALSE.
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: question on qualifiers
Welcome to the Forums.
This may sound obvious, but did you look at the STYLE function in the help file?
Please note that you do have to set up your styles in advance to do this.
An alternative is to use a custom number format, so that a positive response is green and a 0 is red.
By default, a TRUE response has a value of 1, and a FALSE response a value of 0
You can get more information about this option by searching the Index of the help file for "number formats;codes" (without the quotation marks)
This may sound obvious, but did you look at the STYLE function in the help file?
Please note that you do have to set up your styles in advance to do this.
An alternative is to use a custom number format, so that a positive response is green and a 0 is red.
By default, a TRUE response has a value of 1, and a FALSE response a value of 0
You can get more information about this option by searching the Index of the help file for "number formats;codes" (without the quotation marks)
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.