[solved] Macro to apply formatting to each referenced cell of a formula

[raystafarian]

Hi All,

Say I have a formula that sums data across sheets. I want to highlight (or bold, ultimately format) each cell that is referenced in that formula. I want it to do this through a macro

How could I accomplish this?

[royUK]

Why? There's formula tracing tools or double click on the formula

[raystafarian]

Why? There's formula tracing tools or double click on the formula

right but if you switch sheets to go find the reference, the tracing disappears. Unless I'm doing it wrong.

Ultimately say I want them all to be Bold with yellow fill, I can't alter the format during tracing, it will change the formula

[royUK]

See if Aaron Blood's Formula Auditing tool helps

[raystafarian]

See if Aaron Blood's Formula Auditing tool helps

Perfect, thanks

[royUK]

Thanks for the rep, please mark this Thread Solved & maybe send Aaron a thank you