Mark Bolton
09-27-2020, 7:32 PM
Been trying to find a reasonably simple way to have all the cells used by a formula in a cell be fill colored a given color if that makes sense.
So say a sheet with 300 line items (rows) and then you have a cell with a simple SUM formula adding up 25 of the items that are scattered throughout the sheet. I was hoping for some way to color the cell with the forumla and have it automatically color any cells used in the formula. I can do it manually but was hoping for something automatic so if additional cells are added or removed from the formula it would just happen automatically.
The sheet is just a simple list of numerical values and on the side I have cells with total xyz, total pdq, total blah blah, pulling from items in the list. Id like to have each of the totals a given color and also color the cells that make up that total the same color.
Sorry for the ramble. Done a bunch of searching and so on with regards to conditional formatting and so on but coming up empty.
So say a sheet with 300 line items (rows) and then you have a cell with a simple SUM formula adding up 25 of the items that are scattered throughout the sheet. I was hoping for some way to color the cell with the forumla and have it automatically color any cells used in the formula. I can do it manually but was hoping for something automatic so if additional cells are added or removed from the formula it would just happen automatically.
The sheet is just a simple list of numerical values and on the side I have cells with total xyz, total pdq, total blah blah, pulling from items in the list. Id like to have each of the totals a given color and also color the cells that make up that total the same color.
Sorry for the ramble. Done a bunch of searching and so on with regards to conditional formatting and so on but coming up empty.