Bob,

Thanks for the reply. My next question is: Is there some way to delete cells
with the formatted background, either through a macro or some function?


"Bob Phillips" wrote:

No, but you can add conditional formatting to the cell, and test the value
there and set the format accordingly.

--
HTH

Bob Phillips

"neeses" wrote in message
...
We run a macro that selects duplicates and formats with background with a
color. We need to include that cell formatting in an IF statement. Can it
be
done and, if so, what would be the syntax?