Live Database Sage to Excel using Microsoft Query - Colour change when data is changed.

Hello all,

I hope someone can help me with my excel issue or at least show me how and point me in the right direction.

We currently have set up a live spreadsheet connected to Sage Accounts, that when we change something on sage and click refresh on excel, the spreadsheet then updates.

It works fine, however, ideally we need to take it a step further and when a change occurs if the text that's changed turns red or a different colour or goes bold or anything to show it has changed, that would be ideal!

My coding for excel is extremely limited/non existent. If someone can help me with this i'd be extremely grateful.

Thanks,

Nathe

It has been built using the 70's technology. It should have been binned. Try to call Sage's support, you need a degree in IT.
I can not stand this over-hyped software. My blood pressure shoots to the roof when ever someone mentions it.