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?