I am trying to conditional format cells with a value that comes from a
formula
say mid(e6,5,4) = 2004 I want all 2004 values to show bold and red. But
can't seem to get the hang of it.


--
Delaina
------------------------------------------------------------------------
Delaina's Profile: http://www.excelforum.com/member.php...o&userid=24151
View this thread: http://www.excelforum.com/showthread...hreadid=392324