Code for Highlighting cells linked to formula

Hi,

if I need to highlight all cells linked to a formula cell

Example Revenue Cell result from adding different cells in the workbook, I need to highlight those cells

If the cells are on the same worksheet you can just select your formula cell then Find & Select > Go To Special... > Precedents . Then you can just select your fill color.

If there are cells on other worksheets you may need to split the cell references within the formula to an array, then loop over them, checking if each one is a valid cell reference, before applying a cell color.

Unfortunately I'm not in a position to be able to write any code for this at the moment.