Conditional formating RRS feed

  • Question

  • Hi,

    I have this large amount of data, about 30k+ rows and 10 columns. I used highlight duplicate cell rules conditional formatting. I want to copy the columns separately without loosing the color.

    1. I am not able to use filter by color or sort by color. Everytime i do it, excel hangs and stops responding hence crash.

    2. I can not copy the single  coloumn with the color that it is highlighted with. While copying it loses the color.

    Need urgent help, thanks.

    Saturday, November 2, 2019 5:18 AM

All replies