| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting Multiple Columns | Excel Worksheet Functions | |||
| Multiple Conditional Formatting | Excel Discussion (Misc queries) | |||
| multiple conditional formatting | Excel Worksheet Functions | |||
| conditional formatting to multiple cells | Excel Worksheet Functions | |||
| How do I use conditional formatting for multiple rows? | Excel Worksheet Functions | |||
Linear Mode
