| 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 | |||
Hybrid Mode
