Conditional format based on a different column

[ArcticWolf]

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

 

[Bernard Liengme]

Select the range of Z cells to have the format
Use FormulaIs =ISTEXT(E1) and click the Format button to give the cells some
format
If you first Z cell is Z22 use =ISTEXT(E22)
Note that a number is E1 will not pass the ISText test
If you want to check for any type of entry use =NOT(ISBLANK(E1))
Success comes from experimentation
best wishes

 

[David Biddulph]

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