[Solved] Question on qualifiers

Discuss the spreadsheet application

[Solved] Question on qualifiers

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

have a formula:

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
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.
Posts: 7680
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 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
Posts: 6062
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Return to Calc

Who is online

Users browsing this forum: Google [Bot] and 13 guests