If statement for text

[decanno04]

I have a conditional format in cell d18. If d18=green, then the text is
green. If d18=red, then text is red. I want to have the same kind of formula
for the E cells. Something like: If d18=green, then c18 characters is green.
If d18=red, then c18 characters is red.

 

[Bob Phillips]

Use a formula of =$D18="green"

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[CLR]

Assuming the "E cells" was a type-o, this procedure will Conditionally
Format C18

Select C18, then do Format > ConditionalFormatting > and Condition 1
settings as follows
Formula Is =D18="green"
then press the Format button and select the Font tab and choose GREEN color

OK

Then click the Add button and Condition 2 settings as follows
Formula Is =D18="Red"
then press the Format button and select the Font tab and choose RED color >
OK


Vaya cn Dios,
Chuck, CABGx3