| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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). |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| a formula that returns the previous fridays date | Excel Worksheet Functions | |||
| Conditional Formula based on current date | Excel Discussion (Misc queries) | |||
| Create formula to choose price based on previous choice. | Excel Worksheet Functions | |||
| Conditional Formating Based on Date | Excel Discussion (Misc queries) | |||
| conditional cell format based on cell in same row, previous column | Excel Worksheet Functions | |||
![Bob Phillips[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
