Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am new to this forum and a poor Excel user. I need to create a
tickler to inform me when a specific (180) number of days passes a date in a cell. The starting date will be different in each consecutive cell of a column but the 180 days is constant. I did a search and I think I found the information I need, but I cannot decipher it to my specific equation since I am a poor Excel user. Thanks --- Message posted from http://www.ExcelForum.com/ |
#2
![]() |
|||
|
|||
![]()
Creating a Tickler for a Date + 180 Days in Excel
Note: This will serve as a tickler to remind you that 180 days have passed since the starting date in column A.
__________________
I am not human. I am an Excel Wizard |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Select your column of date cells.
FormatConditional FormattingCell Value is: Less Than =TODAY()-179 Select a Pattern Color from the Format Button then OK your way out. When the date in a cell is 180 days old it will change color. Gord Dibben Excel MVP On Wed, 7 Jan 2004 17:46:16 -0600, ram1000 wrote: I am new to this forum and a poor Excel user. I need to create a tickler to inform me when a specific (180) number of days passes a date in a cell. The starting date will be different in each consecutive cell of a column but the 180 days is constant. I did a search and I think I found the information I need, but I cannot decipher it to my specific equation since I am a poor Excel user. Thanks --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need to pull <=14 Days, <=30 Days, 30 Days from a date column | Excel Discussion (Misc queries) | |||
Is there any way to set up tickler files in exel? | Setting up and Configuration of Excel | |||
Conditional Formatting Dates calculating 10 days and 30 days from a certain date | Excel Worksheet Functions | |||
Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
How do I set up a tickler file? | Excel Discussion (Misc queries) |