Multiple Conditional Formatting-HELP
 

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.

Multiple Conditional Formatting-HELP
 

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

=OR(K1<100,L1<100,E160)

HTH

Bob

"Cindy" wrote in message
...
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.

Multiple Conditional Formatting-HELP
 

PERFECT, Thanks so much!

"Bob Phillips" wrote:

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

=OR(K1<100,L1<100,E160)

HTH

Bob

"Cindy" wrote in message
...
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.


.