IF THEN Conditional Formulas

[LTPLegend]

Hello,

B7 has a number calculated from two other cells, it is how many days old something is.
D7 has one of three words to show how serious something is

I want to change the color of B7 depending on what number it is, for example

IF
D7 = HIGH
AND
B7 = 15
THEN
Fill Orange

Conditional Format checks D7 for what number range it should use, then checks B7 to see where it falls in that range and colors it.

Three sets of Number Ranges Based on Priority:
High means:
0-15 days Blue to Orange Color Fill
15-30 days Orange to Red Color Fill
After 30 days true Red Fill

Medium means:
0-30 days Blue to Orange Color Fill
30-60 days Orange to Red Color Fill
After 60 days true Red Fill

Low means:
0-45 days Blue to Orange Color Fill
45-90 days Orange to Red Color Fill
After 90 days true Red Fill

Thank you!

 

[Latchmaker]

You will need to use 9 different formulas and criterias within conditional formatting set the formating accordingly to your desires.
=and(D7="HIGH",B7<15)
=and(D7="HIGH",B7<30)
=and(D7="HIGH",B7>29)
=and(D7="MEDIUM",B7<30)
=and(D7="MEDIUM",B7<60)
=and(D7="MEDIUM",B7>59)
=and(D7="LOW",B7<45)
=and(D7="LOW",B7<90)
=and(D7="LOW",B7>89)