Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi,
I have a worksheet that on Col A I need a "tickler" to prompt me to update a particular row based on date requirement on column B (i.e., every 30, 60 or 90, etc days). I came up with a conditional formating on Col A, row 2: =datevalue("2/25/2008"), will make a yellow background/pattern Right now, I have to adjust the dates every 30, 60, days to promt me to update. An if function will also do: (please edit the formula below) =IF(NOW()=DATEVALUE("1/3/2008"), " Update!","****") If there a way to edit my conditional formatting or if formual to make it prompt every 30, 60, etc. days. Thank you in advance. Danny |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional formatting with IF function | Excel Discussion (Misc queries) | |||
Conditional formatting with IF function | Excel Discussion (Misc queries) | |||
Conditional Formatting with IF function | Excel Worksheet Functions | |||
Help on a function with Conditional Formatting | Excel Worksheet Functions | |||
Conditional Formatting (IF function) | Excel Worksheet Functions |