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


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