Is there a way to automatically copy a cell color from another cell just based on the color of the cell without using VBA or a value?
I have a chart with many of the same values but they have different colors in each cell (so using conditional formatting based on values wouldn’t work) and im trying to have a new subset chart automatically filled from that data (using the vlookup function) but I would need the cell colors to transfer over as well.
Thank you
I have a chart with many of the same values but they have different colors in each cell (so using conditional formatting based on values wouldn’t work) and im trying to have a new subset chart automatically filled from that data (using the vlookup function) but I would need the cell colors to transfer over as well.
Thank you