Possible conditional formatting?

G

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 A1:D1 range is populated
with "comp", keeping the narrative in E1 "ABCDE"

All help much appreciated

Thanks,
Gary
 
J

Jason Morin

Under CF, choose Formula Is and use:

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

HTH
Jason
Atlanta, GA
 
Top