View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default 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?