[Solved] Question on qualifiers

Discuss the spreadsheet application

[Solved] Question on qualifiers

Postby macjohn79 » Thu Apr 25, 2019 9:40 pm

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
Last edited by macjohn79 on Fri Apr 26, 2019 2:13 pm, edited 1 time in total.
Open office 4.1 / windows 7
macjohn79
 
Posts: 3
Joined: Tue Apr 23, 2019 3:12 pm

Re: question on qualifiers

Postby FJCC » Fri Apr 26, 2019 4:13 am

You can do this through the menu Format -> Conditional formatting. Use the value 1 to match TRUE and 0 to match FALSE.
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7354
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: question on qualifiers

Postby RusselB » Fri Apr 26, 2019 4:14 am

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)
OpenOffice 4.1.7 and LibreOffice 6.3.3.2 on Windows 7 Pro & Ultimate
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.
User avatar
RusselB
Moderator
 
Posts: 5601
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON


Return to Calc

Who is online

Users browsing this forum: MSN [Bot] and 14 guests