Conditional Formatting based on a cell value
Do you know of a way to do the following:
I have to choose if cell "C5" is either "direct" or "stock" - got that part
down (validation)
In cell G5, I want to have one set of conditional formatting if C5 is
"direct" and another set of conditions if C5 is "stock"
Example:
If C5 is stock, then I want G5 to be
Green if the value of G5 is 20%
Orange if the value of G5 is 15%
Red if the value of G5 is <15%
If C5 is direct, then I want G5 to be
Green if the value of G5 is 10%
Orange if the value of G5 is 7%
Red if the value of G5 is <7%
Any ideas?
|