| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formating-change color of cells over than one with for
"carrera" wrote: Let's say in D55 on each sheet is a formula showing a cumulative total from the prior sheets If the cumulative total in D55 is less than 40, I'd like cells in rows 1 through 49 to be green, if over 40, turn the cells red. In other words, can I make the condition formating dependant on a totally different cell? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formating between 2 workbooks. | Excel Worksheet Functions | |||
| conditional formating a specific amount of cells in a row. | New Users to Excel | |||
| Conditional Format to change entire row based on one cells data | Excel Discussion (Misc queries) | |||
| conditional formating using cells containg dates | Excel Discussion (Misc queries) | |||
| How to change an entire row using conditional formating | Excel Discussion (Misc queries) | |||
Threaded Mode
