Remove conditional Format but retain cell format

aithalkashyap 

I found you can change your conditional formatting to also add text to the cells. just go to the custom part of number formatting for the text. whatever format you want, then a space, then SELECTALL or something. after your conditional formatting adds the text, you can go to "find" then with the value of SELECTALL choose "find all". it'll give you a list below of the cells. click on one result in the box, then hit "ctrl-a" on your keyboard to select all the cells with conditional formatting. choose whatever formatting you wanted to keep now. then you can clear the SELECTALL part from conditional formatting and you're done.

i realize that's a lot of steps, but if you're really set on getting it to work, this was the only way i could find, short of using a macro that would break my "undo" history.