Conditional Formatting

[dhamilton215]

I am attempting to conditionally format a cell in the G column to change to red fill if the date referenced in it is within 3 months from today but excel only allows you to do it up to this month. I was wonder if someone could help me either get that formula started or show me where to find the information to figure it out?

 

[oldbrewer]

in a spare part of your spreadsheet say Z1 =today()+91

assuming a date is in A1 formula is = (Z1-A1) <91

 

[dhamilton215]

Thank you so much