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.

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.

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.




.