I have compaired lists using condition formating, now I need to work with one
of these lists, but need to know the information the conditional format has
given me.
Once I copy out the list, I loose the conditions and thus the format.
Is there a way to convert the conditional formating to standard format?