In column F, I have a summary total number of customers that will be lost over a certain time at a given location (each row is a different location). In column G, I have the name of the rep responsible for those customers. I've used the Red-Yellow-Green color scale on column F to show in green which ones are losing no customers, and scale the gradient up to red to show which ones are losing the most. Easy enough.
I would like for the cells with the rep's names in column G to have the same color scale formatting as was assigned by Excel's conditional formatting rule to column F.
Is this possible? I know how to conditionally format the a cell based on another cell's value, but not to do it in an automatic color scale manner.
dt
Bookmarks