Something like:

=MID(E6,5,4) ="2004"

But if that formula is really returning a date:
=year(e6)=2004
would work better.



Delaina wrote:

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

--

Dave Peterson