Request for Conditional Formatting help

Copper Contributor

I have an invoice I made for Independent contractors. 

The fee column is restricted to them so I have to update it to a higher rate once the client has been with them (their coach) for 12 months. 

The formula I was using was: =DATEDIF(D2,TODAY(),"Y")>0 

D Column = a specific date 

 

NOW the invoices need to be updated as I will have to update the fee at both 13 and 37 months from the date in column D.  

 

Should this be two formulas? I'd like for the 13 months and the 37 months formatting to be different colors. 

 

TIA 

 

 

1 Reply

@isthatkaitlin 

You could use

 

=DATEDIF(D2,TODAY(),"M")>=13

 

and

 

=DATEDIF(D2,TODAY(),"M")>=37

 

in two different rules.