How to make cells in one column change fill colors base off of two conditions

[dstimpson]

Hello,

I am looking to have a column of dates (column G) fill GREEN based off the conditions:
1. If there is a "P" (stands for portables) in column F
2. If the date listed in column G is over one year old (365 days+)

I am also looking to have the same column of dates (column G) turn GREEN based off the conditions:
1. If there is a "RI" in column F
2. If the date listed in column G is over 6 months

And vis versa for each but the columns would be turning RED if less than 1 year/6 months respectively

I appreciate any help!

 

[6StringJazzer]

Rule for green, select entire column and add rule using a formula:
This will also take leap year into account.

=OR(AND(F1="P",G1<DATE(YEAR(TODAY())-1,MONTH(TODAY()),DAY(TODAY())),AND(F1="RI",G1<DATE(YEAR(TODAY()),MONTH(TODAY())-6,DAY(TODAY())))))

Rule for red:

=OR(AND(F1="P",G1>=DATE(YEAR(TODAY())-1,MONTH(TODAY()),DAY(TODAY())),AND(F1="RI",G1>=DATE(YEAR(TODAY()),MONTH(TODAY())-6,DAY(TODAY())))))

Adjust the "<" and ">=" signs for your specific needs

 

[ranman256]

col.H has the # months of the date used.
Use Conditional Format in the cell:

condition: Format values where this condition is true
value: =AND($H2>6,$F2="RI")
fill color: green