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
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