No you have to delete the formats.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Simon Lloyd " wrote in message
...
Is it possible to turn conditional formatting off at the start of a
macro and then apply he conditional formatting back to the cell after
the macro has run? (when i say conditinal formatting i mean the built
one in Excel)

Simon


---
Message posted from http://www.ExcelForum.com/