ExcelBanter - Conditional Formula based on previous date + 30

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Conditional Formula based on previous date + 30 (https://www.excelbanter.com/excel-discussion-misc-queries/258669-conditional-formula-based-previous-date-30-a.html)

Chris

Conditional Formula based on previous date + 30

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).

Bob Phillips[_4_]

Conditional Formula based on previous date + 30

Just use CF with a formula of

=B2TODAY()

--

HTH

Bob

"Chris" wrote in message
...
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).

All times are GMT +1. The time now is 05:29 PM.