Suggest you RE-read my post about not changing previous cells.

--
Don Guillett
SalesAid Software

"Carroll" wrote in message
ups.com...
Don,

After some testing with the VBA code you provided, I notice that my
underlying conditional formatting did actually stay intact. However
what was weird was that all cells that I had colored previously all
turned white as soon as I move just one cell over.

I like your code and will keep it for another situation, but does
anyone know how to do this with conditional formatting? I did look at
the cell function, but I didn't see how I could use that with
conditional formatting to color the active cell.

Thanks,

Carroll