Does your cell contain:
1. only "March"
2. "March" as part of other text, e.g. "The Ides of March"
or
3. A date formatted to read something like "3rd March 2006"?
Either way you could use
Format Conditional formatting formula is
=A1="march"
=SEARCH("march",A1)
or
=MONTH(a1)=3
--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile:
http://www.excelforum.com/member.php...o&userid=30486
View this thread:
http://www.excelforum.com/showthread...hreadid=514568