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!
|