Using IF Function

O

Old Red One

If the number in B1 is greater than the number in A1 and the word to appear
is INVERTED then =IF(B1>A1,"INVERT","NORMAL") works in C1. How can I format
cell C1 so that it is red for INVERT.
 
D

Dave Peterson

Take a look at Format|conditional formatting.

You can change the format based on the value in the cell.
 
Top