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