Click on the dropdown arrow at FormatCFCondition1 "Cell Value is"


Gord Dibben MS Excel MVP

On Fri, 2 May 2008 15:07:01 -0700, Please explain more specifically <Please
explain more wrote:

Dear SteveG

I don't understand how to change the cell value is option to formula is.
Can you explain more specifically ?

Thanks in advance.

Peter

"SteveG" wrote:


Christine,

Yes. In A1 go to Conditional Formatting. Change the Cell Value is
option to Formula is. Enter

=B1="Your Text"

Click Format, Font select the color you want. Click OK, OK.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=570036