The conditional format function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to change the font color in a cell if my equation comes up true or
false. I've tested the equation , both results show ("true" or "false")
however only one color shows with two conditions set in the cond. format
tool. Here is my formula which tests if the value in the cell prior is
greater than 80. If so, the difference is posted and I want that text in red,
if not, then text in any other color.
IF(N23>0.8,(N23-0.8), "ok")
 
Assuming that the formula is not in cell N23, just use a formula of

=N23>0.8

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting for cells with formulas 1
Search For A Column Width in Conditional Formatting 3
Conditional Formatting 1
Nested Functions for Conditional Formatting Formula 3
Conditional Formatting 3
Changing cell colors from a function command 3
If function with format 1
IF OR AND in same conditional formula 2

Back
Top