Quote Originally Posted by bakerman View Post
In your example file from Post#4 this works just fine for me so something must be different in your original file.
I'd guess emmye998 either has no constants in column A, or formulae.
So the file probably isn't representative of what he has.
I didn't get an answer to one of my questions:
Is the colour of the conditional format always because of a single formula (or can several different formulae lead to the same colour)?

So we need a representative file.
Conditional formatting in Excel 2003 is more basic and there isn't a cell's .DisplayFormat.Interior.Color until Excel 2010.
So finding whether a cell's conditional format is returning a given color to the cell can be complex in Excel 2003.

Normally, in code, I'd autofilter the range on a column or columns, copy and paste to another location, then remove the filter. However if may be more complex than that with emmye998's file since there may be more than one conditional format formula returning the same colour, hence my question. It may be easier to add helper column(s), hidden if you want, filter on them and then copy/paste.