I have a spreadsheet that currently conditionally formats some cells, changing the background color. I am trying to copy/paste these cells and preserve the color of the background without having to copy in all the data required for the conditional formatting.
More specifically: I am conditionally highlight the cells in column A based on the data in column B. I want to be able to copy column A to another sheet and preserve which items in column A have been highlighted. I do not want to copy the data from column B into the new sheet.
Is there a way to do this?