Alert of 2-3 days before 30 day follow up

[tdodson]

Hello,

I need a formula to be a follow up field to calculate 30 days(from previous cell); identify by color when date is within 2-3 days of 30 day follow-up

So in J2, I have a date. I need K2 to follow up that date by 30 days. I know the formula is =J2+30. That is the locked formula. Then I go to Conditional Formatting - Highlight Cell Rules - More Rules and then I have a place to put the formula in. I made it Cell Value is less than or equal to:



So far I have =K2-TODAY()-3
I formatted the font to be red when it alerts.
But the formula is incorrect. I have no idea how to make it work.

Any help would be appreciated.

Thank you

[Pecoflyer]

So K2 should turn red?
Select K2 - CF - Manage Rules - enter following formula =TODAY()-J2>=30 the format as needed

If it still does not work post a sample file - Thx

[tdodson]

Thank you! I really appreciate you help.