I would be very glad if anybody in this forum can help me with one of my
unknown.

from a large spreadsheet, filled with data and formulas, no outside
worksheet linking, I like to have the cells to have conditionally filled
colors,

e.g (in one sheet).
if one cell is use in a formula by other cellS, i need it to have an
automatic color

the gradient of colors can be chosen as you can suggest, and must depend on
the following intermittent range of condition
1. if a cell is referred by a formula by about -say maximum- 1000 times
then the color should be gold,
2. when the cell is the least referred by a formula by about - say minimum -
1 time then the color should be light green.
3. for cells used on intermittent times, u can suggest colors.

maybe this is possible to help me clean up many large muddy files - with
irrelevant data.

thanks for any suggestion.