Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cond. Format Formulas
This is a revised/corrected thread. I need three
conditional format formulas for the following: Intent: Color format the background of cell M30 based on its value: 1.) Green when: <M20 and M24 2.) Yellow when: <M18 and =M20, or, <=M24 and M27 3.) Red when: =M18 or <=M27 4.) If B30 is blank, no format applied - defaults to white Values: ----- Red ----- M18 100% ---- Yellow ---- M20 95% ----- Green ----- M24 85% ---- Yellow ---- M27 80% ----- Red ----- B30 Value, a percent, determined by formula. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cond. Format Formulas
Change cell value is to Formula is:
=And(M30<M20,M30M24) =OR(And(M30<M18,M30=M20),And(M30<=M24,M30M27)) =OR(M30=M18,M30<=M27) -- Regards, Tom Ogilvy "Phil Hageman" wrote in message ... This is a revised/corrected thread. I need three conditional format formulas for the following: Intent: Color format the background of cell M30 based on its value: 1.) Green when: <M20 and M24 2.) Yellow when: <M18 and =M20, or, <=M24 and M27 3.) Red when: =M18 or <=M27 4.) If B30 is blank, no format applied - defaults to white Values: ----- Red ----- M18 100% ---- Yellow ---- M20 95% ----- Green ----- M24 85% ---- Yellow ---- M27 80% ----- Red ----- B30 Value, a percent, determined by formula. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Thanks
Tom, works just as needed. Thank you for your time and
help. Happy Holiday! -----Original Message----- Change cell value is to Formula is: =And(M30<M20,M30M24) =OR(And(M30<M18,M30=M20),And(M30<=M24,M30M27) ) =OR(M30=M18,M30<=M27) -- Regards, Tom Ogilvy "Phil Hageman" wrote in message ... This is a revised/corrected thread. I need three conditional format formulas for the following: Intent: Color format the background of cell M30 based on its value: 1.) Green when: <M20 and M24 2.) Yellow when: <M18 and =M20, or, <=M24 and M27 3.) Red when: =M18 or <=M27 4.) If B30 is blank, no format applied - defaults to white Values: ----- Red ----- M18 100% ---- Yellow ---- M20 95% ----- Green ----- M24 85% ---- Yellow ---- M27 80% ----- Red ----- B30 Value, a percent, determined by formula. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rounding / Cond. Format | Excel Discussion (Misc queries) | |||
Whole Row Cond. Format | Excel Discussion (Misc queries) | |||
cond format | Excel Worksheet Functions | |||
HLookup or Cond. Format? | Excel Worksheet Functions | |||
Display Cond. Format Formulas | Excel Discussion (Misc queries) |