Conditional format based on a different column
 

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

Conditional format based on a different column
 

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"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

Conditional format based on a different column
 

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