View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Trevor Shuttleworth
 
Posts: n/a
Default simple conditional formatting

If you've got quotes around the formula, it's *not* working

Don't quite see how the formula relates to the conditional formatting you
want.

Use Formula is =F11C11

Regards

Trevor


"bcamp1973" wrote
in message ...

ok, i'm new to all this so i'm sure i'm overlooking something simple,
however i'm trying to do some simple conditional formatting. i want to
say, if cell F11 is cell C11 then make the text in cell F11 red. In
the conditional formatting window I've selected "formula is" and
entered this...

="IF((C11-(E11-(C11*$C$3/$C$6)))C11)"

nothing is happening i know the formula is working so it's not
that...what am i overlooking?


--
bcamp1973
------------------------------------------------------------------------
bcamp1973's Profile:
http://www.excelforum.com/member.php...o&userid=32268
View this thread: http://www.excelforum.com/showthread...hreadid=521209