How do I use a formula to make certain text a different color?
 

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 "March" text to
automatically be in green).

How do I use a formula to make certain text a different color?
 

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

How do I use a formula to make certain text a different color?
 

Many Thanks!

"daddylonglegs" wrote:


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