Conditional highlight

C

chermaine

Right now I am preparing a spreadsheet and I would like to know is
there any way can help hightlight the cells if the item filled in is
not equal to "IDL or TMR"?
 
J

James T

Chermaine,

This is a standard function within Excel.

1) Highlight the cells that you want to apply this condition too
2) Choose FORMAT/CONDITIONAL FORMATTING.

You can then define mutliple formatting requirements for these cells
(including colouring).

Regards

James
 
Top