Thread: Auto Formatting
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David David is offline
external usenet poster
 
Posts: 1,560
Default 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.