Hi all,

I have a command button on a sheet.

I'd like a macro to scan the workbook and find all cells which contain a function/calculation and then change the colour of the cell.

Can this be done and if so, how?

Thank you