Conditional highlight
 

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

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


"chermaine" wrote:

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