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.