Page 1 of 1

[Solved] Question on qualifiers

PostPosted: Thu Apr 25, 2019 9:40 pm
by macjohn79
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

Re: question on qualifiers

PostPosted: Fri Apr 26, 2019 4:13 am
by FJCC
You can do this through the menu Format -> Conditional formatting. Use the value 1 to match TRUE and 0 to match FALSE.

Re: question on qualifiers

PostPosted: Fri Apr 26, 2019 4:14 am
by RusselB
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)