Hi there,
Does anyone knows how i can remove Conditional Formatting but keep the format which has been done via conditional format?
Thanks.
Hi there,
Does anyone knows how i can remove Conditional Formatting but keep the format which has been done via conditional format?
Thanks.
Select the cell(s) in question, go to the conditional formatting tab, select "Clear Rules" and then "Clear Rules from Selected Cells"
Edit:
Sorry I didn't read closely enough. Will look into.
Last edited by liquidmettle; 01-03-2016 at 03:14 AM.
i want to keep formats..
Hi Dev,
Look into this thread for links to similar threads or possibly a solution through the macros posted. I have not tested them myself
http://www.mrexcel.com/forum/excel-q...ed-format.html
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks