Use a formula of =$D18="green"
--
HTH
RP
(remove nothere from the email address if mailing direct)
"decanno04" wrote in message
...
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.
|