I've tried using the format painter as well as paste special - formats. The
results are an absolute reference to the conditional format formula I've
copied from, and not reference to the cells I've copied the formula to. I
have to go in and manually edit the formula. Please advise if there is an
easier way.