Conditional Formula based on previous date + 30

C

Chris

I have a spread sheet that caluclates when proposals expire.

Date Sent Follow Up date
January 13, 2010 February 12, 2010

What I am looking for is for the Follow up date to turn RED when the date is
expired (over the date listed).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Datedif gives wrong result 1
Attempting to compare and deduct values based on date codes 3
Conditional Format where ANY date is >= 30, 60, 90 days EXCEL 2007 1
Macro to goto specific cell (todays date) 4
Using CF to change colour in cell based on date? 4
Calc Date Based on Year 3
Conditional Formula based on current date 5
conditional formula with date 6

Top