Conditional Formatting (I think)

[Graeme]

Hello

I am publishing an Access db report in Excel and
distributing it to several people for comments. I would
like to do something so that any cells they alter will
change colour for easy identification.

Not sure if this is conditional formatting or a function
or VB language.

Can anyone help?

Thanks
Graeme

 

[Debra Dalgleish]

You can use the Tools>Track Changes feature to mark the cells that have
been changed. However, this also shares the workbook, which creates some
limits on how the workbook can be changed. Check Excel's help for
'Features that are unavailable in shared workbooks'

 

[Norman Harker]

Hi Graeme!

Take a look at:

Tools > Track Changes.

Seems to do what you want.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.