Colouring a YES result?

[Terry Pinnell]

I'm struggling to write a formula that would make all cells with YES
have red text, while NO remains the black default.

FWIW, the cell already contains a longish formula
=OR(IF(ABS(C4-1.33)<=0.01,TRUE,FALSE),IF(ABS(C4-1.77)<=0.01,TRUE,FALSE))
(to decide whether the cells in col C are either between 1.33 and 1.34
or between 1.77 and 1.78). I just want to add the finishing touch of
colouring the YES results.

It's frustrating, as I'm sure I've done it before a few years ago!

 

[Roger Govier]

Hi Terry

Format>Conditional Formatting>Cell Value is>Choose Equals in
dropdown>enter TRUE in white pane
Format>Font>Red

 

[Guest]

Try Conditional Formatting,
CellValueIs - ="Yes" (In text box)
Select Font Color RED
OK out..

 

[Guest]

This is a whole lot easier with conditional formatting. Go to FORMAT |
Conditional Format

Set it to CELL VALUE is EQUAL TO YES and change the format to red text.

I'm not sure where you are getting a "YES" result from your equation however.

 

[Guest]

Hey Jim, do you live in MD?

Try Conditional Formatting,
CellValueIs - ="Yes" (In text box)
Select Font Color RED
OK out..

 

[Terry Pinnell]

This is a whole lot easier with conditional formatting. Go to FORMAT |
Conditional Format

Set it to CELL VALUE is EQUAL TO YES and change the format to red text.

Of course, Conditional Formatting - thanks all!

I'm not sure where you are getting a "YES" result from your equation however.

You're right; that was pasted prematurely, one step short of the
finish! Here's the formula that gives me Yes - in red <g>

=IF(AND(AND(NOT(MOD($A4,16)),NOT(MOD($B4,16))),OR(IF(ABS($C4-1.33)<=0.01,TRUE,FALSE),IF(ABS($C4-1.77)<=0.01,TRUE,FALSE))),"Yes","No")