D
dribler2
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.
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.