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