Forum Discussion
Remove conditional Format but retain cell format
Hi, I have big sheets with too many conditional formats. I used conditional format for cell coloring, cell border, number format, text alignment etc. These I did through different conditions such "F...
You can copy the affected cells to your clipboard and re-paste them. Refer here:
https://www.quora.com/How-can-I-remove-conditional-formatting-but-keep-the-color-formats-in-Excel
https://www.quora.com/How-can-I-remove-conditional-formatting-but-keep-the-color-formats-in-Excel
Thanks PReagan,
But copy and paste the clipboard content works only for small amount of data as I noticed in my case always; for those big amount of data, pasting clipboard content doesn't include conditional format at all...!
