ExcelBanter - Change cell color if used in a formula?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Change cell color if used in a formula? (https://www.excelbanter.com/excel-discussion-misc-queries/446847-change-cell-color-if-used-formula.html)

Drives

Change cell color if used in a formula?

I made a worksheet to figure out the point for my sons go-karting league, it drops the lowest 1st four points days using (-SMALL) in a formula. Is there a way that I could have the sheet highlight the cells it's using in the formula?

All times are GMT +1. The time now is 05:58 AM.