Need help with formula

[annep833]

I have a date in cell c2 and a date in cell b2. I need a formula for conditional formatting where it will fill the cell with red if the date in b2 is more than 2 years from the date in c2. If c2 date is 1/1/2024 and b2 is 1/1/2021, b2 cell gets highlighted red. Thank you!

 

[skillilea]

Add a new cond. formatting - formula with this. Then set you colors and font

=AND($B$2<>"", $C$2<>"", $B$2 > $C$2 + 365*2)

 

[annep833]

Thanks!

 

[skillilea]

You are welcome!