If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Autofill Colour
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. |
#2
|
|||
|
|||
Autofill Colour
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!* "Kanmi" wrote: 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. |
#3
|
|||
|
|||
Autofill Colour
I'm sorry for that. please tell me the step to set it up with macro. thanks
"Luke M" wrote: 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!* "Kanmi" wrote: 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. |
Thread Tools | |
Display Modes | |
|
|