hi,
I have a huge table, that has conditional formatting on each cell. the formatting causes the cell contents to be either red or green. in processing the table, with sorting, copying, and moving parts of data to different sheets, the amount of conditional formatting seems to be growing. is there a way to copy the cells, without the formatting, and have it retain the color. I tried 'paste special values', but that didn't work, as the font turned black, when formatting was removed. I would appreciate any help provided. thanks.
I have a huge table, that has conditional formatting on each cell. the formatting causes the cell contents to be either red or green. in processing the table, with sorting, copying, and moving parts of data to different sheets, the amount of conditional formatting seems to be growing. is there a way to copy the cells, without the formatting, and have it retain the color. I tried 'paste special values', but that didn't work, as the font turned black, when formatting was removed. I would appreciate any help provided. thanks.