Conditional Formatting Help in Office 2007
Hi,
Be aware that F79 has not colour you will not be able to see the information
if the font is white
being in cell f79 go to conditional formating, new rule, where the formula
is, last option, enter
=$E$58:$E$61<0
then go to format, choose font colour
if this helps please click yes thanks
"Erika" wrote:
I am trying to set up a rule for conditional formatting that if cells
E58:E61 are less than zero - the font for cell f79 should be white. Is that
possible to do?
|