conditional formay date maturity

F

Frank

Hi, I will try my best to explain. I need to have conditional formatting as
such:
3 cells in adjacent columns. first has name, second has text missed punch,
third has date of error. I need the 3 cells to be removed(possibly to
another worksheet in same workbook) when the date matures to one year old?
Hmm. Did I make sense? Excel 2003
Thanks so much
Luke
 
J

Joerg

I'm not sure why you *need* conditional formatting to move your data (that's
certainly something formatting can not do), but as long as you just want to
mark those old records and then move them manually (or via macro), here is
what you can do:

Assuming that the date cell is A3, goto Format => Conditional formatting =>
set Condition1 to "Formula is" and in the textbox type the formula
"=A3<NOW()-365" (without quotes), then select a nice format (e.g. red fill
color). Pres OK and copy the cell format as needed.

Cheers

Joerg
 
Top