before you delete any cells, in your code, loop down the conditional format
column, count the number of blank cells in each the row and apply the
appropriate colorindex to the Interior.ColorIndex property for that row.
When the loop is complete then you can remove the conditional formatting so
it doesn't interfere and do the current snap report.

--
Regards,
Tom Ogilvy



"Val" wrote in message
...
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