| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programming question
I am trying to find a formula, and the purpose of this formula is to
determine if there is a date in the cell "Date Funds Wired", and the "Permit Number" cell is blank and the value of the date funds wired plus 730 days (24 months) is greater than or equal to TODAY, then conditional format the "Permit number" cell to turn red. Thank you! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Programming question
Click on Format|Conditional Formatting, change the Cell Value is option to
Formula is, and enter the following: =AND($A$1+730<=TODAY(),B1="") "Kelly" wrote: I am trying to find a formula, and the purpose of this formula is to determine if there is a date in the cell "Date Funds Wired", and the "Permit Number" cell is blank and the value of the date funds wired plus 730 days (24 months) is greater than or equal to TODAY, then conditional format the "Permit number" cell to turn red. Thank you! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Programming Question | Excel Programming | |||
| Not exactly a programming question | Excel Programming | |||
| Programming Question | Excel Programming | |||
| Programming Question | Excel Programming | |||
| Help with programming question | Excel Programming | |||
Hybrid Mode
