is there any automatic colour change function?

  • Thread starter Thread starter angel
  • Start date Start date
A

angel

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??
 
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
 
Be careful with this method.

It will make your workbook "shared" and with attendant problems found with
shared workbooks.


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autofill Colour 2
automatic colour change of cells. 3
Auto Formatting 3
Changing cell colours on a pie chart 0
Automating text colour changes in Excel 2
Remove colour change 4
Access Help with Access 2013 - changing a form field back colour based on another fields entry (Check box) 0
Colour help! 3

Back
Top