Auto Formatting

  • Thread starter Thread starter Freshman
  • Start date Start date
F

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.
 
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
 
Hi David,

Thanks for your tips. However, what should I write in conditional formatting
to get your said result? Thanks.
 
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
 
Back
Top