I have done some conditional formatting on some work which has produced a nice page of colours. What I would like to do is remove the conditional formatting, but keep the colours it produced for the cells in place. Is there a way of doing this? Maybe a macro could sort me out?

Thanks

Beefy