Multiple Conditional Formatting-HELP

[Cindy]

I need the formula for--If K1 or L1 is less than 100, or if E1 is greater
than 60, shade cell A1 to dark gray. Then I would need to carry it down the
length of A column. Using Excel 2007. Thank you.

 

[Bob Phillips]

Select all of the target cells and set the CF using a formula of

=OR(K1<100,L1<100,E1>60)

HTH

Bob

 

[Cindy]

PERFECT, Thanks so much!

Select all of the target cells and set the CF using a formula of

=OR(K1<100,L1<100,E1>60)

HTH

Bob




.