conditional formatting / true and false / colours

[Besh]

=IF(G55=26,"Evaluation Complete","Evaluation Incomplete")

Considering the above, I want "Evaluation Complete" (true) to be in blue font and "Evaluation Incomplete" (false) to be red font.

I'm using Excel 2007, how would I go about doing this?

Thanks, Besh

 

[MrKowz]

Highlight the cell, and on the Home tab, click on "Conditional Formatting">"New Rule"

In here, click on "Format only cells that contain", change to Cell Value -- Equal to -- Evaluation Complete

Click on "Format" and choose the formatting you want.

Then do the same for "Evaluation Incomplete".

 

[T. Valko]

=IF(G55=26,"Evaluation Complete","Evaluation Incomplete")

Considering the above, I want "Evaluation Complete" (true) to be in blue font and "Evaluation Incomplete" (false) to be red font.

I'm using Excel 2007, how would I go about doing this?

Thanks, Besh

Try this...

• Select the cell in question. Let's assume it's cell A1.
• Goto the Home tab>Styles>Conditional Formatting>Manage rules>New rule>Use a formula to determine which cells to format
• Enter this formula in the box below:
  =A1="Evaluation Complete"
• Click the Format button
• Select the Font tab
• From the color drop down select a shade of BLUE
• OK
• OK
• New Rule>Use a formula to determine which cells to format
• Enter this formula in the box below:
  =A1="Evaluation Incomplete"
• Click the Format button
• Select the Font tab
• From the color drop down select a shade of RED
• OK out

 

[Besh]

Works, thanks again!

Besh

 

[MrKowz]

Works, thanks again!

Besh

Cheers! Thank you for the feedback.

 

[T. Valko]

Works, thanks again!

Besh

You're welcome. Thanks for the feedback!