Multiple Conditional Formatting-HELP

  • Thread starter Thread starter Cindy
  • Start date Start date
C

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.
 
Select all of the target cells and set the CF using a formula of

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

HTH

Bob
 
Back
Top