Conditional Formatting

B

baz

Is the following possible?

Conditional Formatting limits you to only three conditions. Is there a
way to get more conditions or do the following.

I am trying to create several, say 10 conditions depending upon
"severity" of the result.

Value 10+ would have light yellow background and Bold black type
Value 6 thru 9.99 would have light green background and Bold black
type
Value 2 thru 5.99 would have light pink background and Bold black type
Value -2 thru 2 would be plain
Value -2.1 thru -5.99 would have light pink background and Bold RED
type
Value -6 thru -9.99 would have light green background and Bold RED
type
Valur -10 and lower would have light yellow background and Bold RED
type

I hope thisis clear.

Thanks in advance for any help.

baz

Please post answer or respond to zgeekz at yahoo dot com as response
email address is bogus to prevent spa
 
Top