User Profile
aithalkashyap
Copper Contributor
Joined Aug 06, 2021
User Widgets
Recent Discussions
Re: Remove conditional Format but retain cell format
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...!16KViews0likes0CommentsRemove 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 "Format only cells that contain - Specific Texts" so eventually I have to remove those additional text to clean it up, but this will remove the format also as the condition fails for that particular cell. So I need a way to remove conditional format and retain format of those cells so that I can remove additional specific text which I used to impose some conditions. I'm no good in VBA coding stuffs, so those "dims" are actually "not" packing much punch to me... 😞 Please help me with something that I can do it in a jiffy....19KViews0likes4Comments
Recent Blog Articles
No content to show