What are your conditional formats and how are they applied? You can loop through the cells and use Select Case. Can you attach a sample file?

lenze