Hi

Mark the range of cells in rows 1 to 49 that you wish to format.
FormatConditional Formatting use dropdown for Formula Is
=$D$55<=40 Set Format Green
Similarly =$D$5540 Set Format to Red

--
Regards

Roger Govier


"carrera" wrote in message
...
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?