Is this what you want? If so, check out the conditional formatting rules I set up. It will give you an idea of some of the ways you can set them up. And remember, rule precedence goes from top to bottom i.e. the first rule takes precedence over the second which takes precedence over the third, etc.
|