Changing the text colour on the result of a calculation

[bamptons]

I would like to be able to change the colour of text in a cell depending on the result of a calculation.

I currently have the formula:

=IF(ISBLANK(C5),"",
IF(C21=C5,"Yes",
IF(C21>C5,"No - Lower",
IF(C21<C5,"No - Higher",))))

I would like "Yes" to be amber text, "No - Lower" to be green text and "No - Higher" to be red text.

Is this possible?

All help gratefully received

Thanks in advance

bamptons

 

[rajibdas]

Hi,

Welcome to the board.

The best way to resolve the above is to use conditional formatting - availabe under:

Format> Conditional Formatting...

Regards

 

[bamptons]

That has sorted it

Thanks

 

[Sir Phoenix]

Please note that conditional formatting is restricted to 3 colors outside of VBA. Which in most cases works well.

 

[rajibdas]

for anything more than three follow the link:

http://www.mrexcel.com/board2/viewtopic.php?t=143108&highlight=