Auto Formatting

[Freshman]

Dear experts,

I have a table with column A containing telephone numbers. My question is,
if I change or add some telephone numbers in column A, I'll fill the those
cells with red colour showing to all users about the change. I want those
cells with red colour change to no colour after 3 days automatically. Is it
possible? If yes, does it require a macro to do so or any other ways? Please
kindly advise.

Thanks in advance.

 

[David]

You could include a last updated column- then use conditional formating to
say if more than 3 days old no background otherwise background in red
Would also allow you review number of updates for certain periods etc

 

[Freshman]

Hi David,

Thanks for your tips. However, what should I write in conditional formatting
to get your said result? Thanks.

 

[Ashish Mathur]

Hi,

In a separate column, have a date entry and in conditional formatting, use
the following formula =today()-date cell>=3

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com