| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
is there any automatic colour change function?
suppose there is a master file with all data saved,
what i want to do is, whenever i reopen this master file and i make some changes of data in some fields, the colour of those field will be changed. so a third party can easily spot which fields have been changed and this is for easy on-going updates purpose is there any ways i can do so in excel?? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
is there any automatic colour change function?
Hi Angel,
On the Review tab, in the Changes group, click Track Changes, and then click Highlight Changes. In the Highlight Changes dialog box, select the Track changes while editing check box. Hope this helps "angel" wrote: suppose there is a master file with all data saved, what i want to do is, whenever i reopen this master file and i make some changes of data in some fields, the colour of those field will be changed. so a third party can easily spot which fields have been changed and this is for easy on-going updates purpose is there any ways i can do so in excel?? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
is there any automatic colour change function?
Be careful with this method.
It will make your workbook "shared" and with attendant problems found with shared workbooks. Gord Dibben MS Excel MVP On Wed, 10 Sep 2008 15:09:02 -0700, pshepard wrote: Hi Angel, On the Review tab, in the Changes group, click Track Changes, and then click Highlight Changes. In the Highlight Changes dialog box, select the Track changes while editing check box. Hope this helps "angel" wrote: suppose there is a master file with all data saved, what i want to do is, whenever i reopen this master file and i make some changes of data in some fields, the colour of those field will be changed. so a third party can easily spot which fields have been changed and this is for easy on-going updates purpose is there any ways i can do so in excel?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I change cell colour to show function used | Excel Worksheet Functions | |||
| Wording's Colour Change for Logic Function | Excel Discussion (Misc queries) | |||
| Criteria - Automatic Change Font or Fill Colour | Excel Worksheet Functions | |||
| Change Font Colour Automatic When Formula Match | Excel Discussion (Misc queries) | |||
| How can I change the colour of cells using an IF function? | Excel Worksheet Functions | |||
Linear Mode
