Sorry, I thought the situation was pretty well stated in the original post.

--
Regards,
Tom Ogilvy

"Bob Phillips" wrote in message
...
Which is why I said should and asked for an indication of the data and the
formulae used.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"Tom Ogilvy" wrote in message
...
Not if the deleted columns contained the blank cells that were
used/counted to establish what the conditional format color should be.

--
Regards,
Tom Ogilvy

"Bob Phillips" wrote in message
...
If you delete columns, the others should adjust and the colours should
remain okay, even though the formulae would adjust.. What does your data
look like, and the CF formula?

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"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