Hi Everyone.
I haven't had any luck finding solutions to this problem on line. Trying to find an alternative to the 'paste data into Word and then paste back into Excel' approach. I want to be able to remove the conditional fomatting of a cell, yet keep the cell formatting (cell background color, font color, etc.).
Has anyone found a VBA solution for this? I've seen solutions for Excel 2003 which don't work in 2010.
Thanks for any help you can offer.
Bookmarks