software

I remember using a formula to make certain text a different color and stand
out, but cannot remember the process. (e.g.- I'd like all quot;Marchquot; text to
automatically be in green).
Does your cell contain:

1. only quot;Marchquot;

2. quot;Marchquot; as part of other text, e.g. quot;The Ides of Marchquot;

or

3. A date formatted to read something like quot;3rd March 2006quot;?

Either way you could use

Format gt; Conditional formatting gt; formula is

=A1=quot;marchquot;

=SEARCH(quot;marchquot;,A1)

or

=MONTH(a1)=3--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=514568Many Thanks!

quot;daddylonglegsquot; wrote:

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