Autofill Colour

[Kanmi]

book1.xls has update link to the database through "function query" mean
whenever there is changes in database file book1.xls automatically run update
it open. i want book1.xls to show colour on those column that has a new
update"for example" if A2 TO N2 has new update then it should show color
column from A2 TO N2. it can be any colour. just want to track which column
has new update or chnages. Please can you master advice on what to do. Thanks
so much.

 

[Luke M]

Please do not post multiple times, it makes it confusing for people trying to
provide help on knowing what has already been suggested.

Because an "update" actually goes through and refreshes all the cells, there
is no simple way of tagging cells with colors. However, you could set it up
(with a macro or manually) so that before update commences, a backup file is
created. Then, have a formula sheet compare new sheet to backup sheet. You
could set it up so that it only displays new data like

=If([Book1.xls]Sheet1!A1<>[Book1Backup.xls]Sheet1!A1,[Book1.xls]Sheet1!A1,"")

 

[Kanmi]

I'm sorry for that. please tell me the step to set it up with macro. thanks

Please do not post multiple times, it makes it confusing for people trying to
provide help on knowing what has already been suggested.

Because an "update" actually goes through and refreshes all the cells, there
is no simple way of tagging cells with colors. However, you could set it up
(with a macro or manually) so that before update commences, a backup file is
created. Then, have a formula sheet compare new sheet to backup sheet. You
could set it up so that it only displays new data like

=If([Book1.xls]Sheet1!A1<>[Book1Backup.xls]Sheet1!A1,[Book1.xls]Sheet1!A1,"")


--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

book1.xls has update link to the database through "function query" mean
whenever there is changes in database file book1.xls automatically run update
it open. i want book1.xls to show colour on those column that has a new
update"for example" if A2 TO N2 has new update then it should show color
column from A2 TO N2. it can be any colour. just want to track which column
has new update or chnages. Please can you master advice on what to do. Thanks
so much.