I applied conditional format to a range of cells in the first column.
Conditional format is based on the number of non-blank cells in each row. I
also made a macro to produce a snap report. Macro eventually deletes a bunch
of columns and I'm loosing the conditional format. The column with
conditionally formatted cells remains intact.

Is there any way I can convert the conditional format into regular format in
my macro so I can keep the colours on my report? If not, any suggestions?

Thanks a lot,

Val