Auto Formatting
 

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.

Auto Formatting
 

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
--
HTH
"Freshman" wrote:

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.

Auto Formatting
 

Hi David,

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

"David" wrote:

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
--
HTH
"Freshman" wrote:

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.

Auto Formatting
 

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

"Freshman" wrote in message
...
Hi David,

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

"David" wrote:

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
--
HTH
"Freshman" wrote:

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.