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.
|