Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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"? |
#2
|
|||
|
|||
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"? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Format to highlight entrire Row | Excel Worksheet Functions | |||
Does a highlight row comand exist for Excel conditional formulas? | Excel Worksheet Functions | |||
Conditional Format to highlight blank cell | Excel Worksheet Functions | |||
Need conditional formatting formula to highlight top ten values i. | Excel Worksheet Functions | |||
Use Conditional Formats to highlight blanks? | Excel Worksheet Functions |