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

Conditional Format where ANY date is >= 30, 60, 90 days EXCEL 2007 1
Formula to fill cells based on Date of Arrival and Date of Departure 1
Macro to goto specific cell (todays date) 4
Using CF to change colour in cell based on date? 4
Attempting to compare and deduct values based on date codes 3
Function for returning quarter based on current date? 4
How can I add the values based the color of font and the date 1
Conditional Formats Date Based 1

Top