| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| autofill colour based on date entered | Excel Discussion (Misc queries) | |||
| autofill colour based on date entry | Excel Discussion (Misc queries) | |||
| how do i autofill a cell a certain colour based on it's value? | Excel Worksheet Functions | |||
| How do I save new colour schemes for graphs in the colour template | Charts and Charting in Excel | |||
| Autofill: Need to autofill one week block, (5) weekday only into cells. | Excel Discussion (Misc queries) | |||
Hybrid Mode
