Alert of 2-3 days before 30 day follow up

tdodson · #1 10-27-2015, 07:07 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
36 days task at 40% effort - only "0.86 days" in resource	hanvyj	Project	9	07-09-2013 07:27 AM
Follow-up Flag Behavior	curtis.walker@sgmc.org	Outlook	1	03-06-2013 08:52 AM
5 days/week during planning & 7 days/week during implementation	sanlen	Project	1	06-25-2012 04:17 PM
follow up missing	ee910285	Outlook	2	05-02-2012 07:29 AM
Check whether Follow Up set	konfis	Outlook	0	10-27-2010 11:19 PM