Home |
Search |
Today's Posts |
#1
|
|||
|
|||
date ?
Please can anyone offer help on how to conditionally format a column of
cells, so that if a date is placed in a cell, ( when I made the visit) the cell will change colour after , say, 22 days from the date entered.( when I need to go again ) I visit students and need to keep regular visits on roughly a 3 week interval and need reminders !! Does this make sense ? Bob |
#2
|
|||
|
|||
Assume dates are in col A, data from row2 down
Select col A Click Format Conditional Formatting Make the settings for condition 1 as: Formula is: =AND(TODAY()-A122,A1<"") Click Format button Patterns tab Orange? OK Click OK at the main dialog Test the triggering by entering a few dates in col A which are more than 22 days ago and a couple which are less than 22 days ago Those which are more should be accordingly colored -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "Nospam" wrote in message ... Please can anyone offer help on how to conditionally format a column of cells, so that if a date is placed in a cell, ( when I made the visit) the cell will change colour after , say, 22 days from the date entered.( when I need to go again ) I visit students and need to keep regular visits on roughly a 3 week interval and need reminders !! Does this make sense ? Bob |
#3
|
|||
|
|||
Hi!
Assume the date is entered in cell A1 Conditional Formatting Formula is: =AND(ISNUMBER(A1),TODAY()=A1+22) Click the Format button and select the style(s) desired OK out Biff "Nospam" wrote in message ... Please can anyone offer help on how to conditionally format a column of cells, so that if a date is placed in a cell, ( when I made the visit) the cell will change colour after , say, 22 days from the date entered.( when I need to go again ) I visit students and need to keep regular visits on roughly a 3 week interval and need reminders !! Does this make sense ? Bob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
How do I calculate if a date is in a certain time frame? | Excel Worksheet Functions | |||
search for latest date | Excel Worksheet Functions | |||
Date difference | Excel Worksheet Functions | |||
Recurring annual events using a specific date as a trigger date | Excel Worksheet Functions |