You need the "Formula Is" part of CF, not "Cell Value Is".
If your selected cell is Z1, use CF/ Formula Is/ =AND(ISTEXT(E1),Z1=2,Z1<4)
for your gold.
Similarly for your red.
Note that you haven't specified what you want if Z = 4
--
David Biddulph

"ArcticWolf" wrote in message
...
Hi,

How can I apply a conditional format to values in column Z if there is a
(text) value in column E? If there is no value in column E then apply no
format.
If value in column Z <2 no format; <4 background colour Gold, textfont
Black; 4 background colour Red textfont Black.

Thanks in advance,

AW