View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kassie kassie is offline
external usenet poster
 
Posts: 268
Default 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!