Possible conditional formatting?

[Guest]

cell A1="new"
cell B1="new"
cell C1="new"
cell D1="comp"
cell E1="ABCDE"

Within conditional formatting, how do I go about filling
E1 in green if any or all of the A11 range is populated
with "comp", keeping the narrative in E1 "ABCDE"

All help much appreciated

Thanks,
Gary

 

[Jason Morin]

Under CF, choose Formula Is and use:

=COUNTIF($A1:$D1,"comp")>0

HTH
Jason
Atlanta, GA

 

[Guest]

many thanks!!

-----Original Message-----
Under CF, choose Formula Is and use:

=COUNTIF($A1:$D1,"comp")>0

HTH
Jason
Atlanta, GA

.