| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
format based on data from another cell
I want the names in column B of my spread sheet to highlight either red or
yellow based on the value of the cell in column L, but with conditional formatting you can only format based on the value of the cell you are formatting, as far as i can tell. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can't format cell - have tried unlocking and unprotecting | Excel Discussion (Misc queries) | |||
| Is there a way to lock out the format for the cell and still allow data entry and C&P? | New Users to Excel | |||
| populating sheets based on data from parent sheets | Excel Discussion (Misc queries) | |||
| Can you conditional format based on information in cell comments? | Excel Worksheet Functions | |||
| Format Cell Colour | Excel Worksheet Functions | |||
Threaded Mode
