code for deleting existing conditional rules and reapplying them back

Hi, I have a spreadsheet with 2 workbooks and in each workbook, there are a few conditional formatted columns. What I would like to do is have a macro that: 1) clears the existing cond. formats. 2)reapply those formats back on to the cells.

The attached file described where the cond. formats are applied. The first workbook contains cond. formats in column N,PQRST(same conditions for pqrst), and column O in the second workbook.

I am ok with having 2 macros: 1 to delete exisiting conditional rules(thereby getting rid of the colors)
2 to reapply the same cond format(reapply color)

Keep in mind that the number of rows could potentially increase at a later date, but the formatting will essentially stay the same. I just dont want the rule to be applied to 4983049288 cells, only the non empty cells.

Thank you in advance for your help!

Originally Posted by hk4kim

What I would like to do is have a macro that: 1) clears the existing cond. formats. 2)reapply those formats back on to the cells.

This makes no sense to me so I must not understand what you're trying to do. Why would you want a macro the deletes conditional formats, then re-creates them?

Do you mean that you want to delete the conditional formatting and use the results of the conditional formatting as permanent formatting? For example, if a cell is less than 7 and has a red fill, remove the conditional format and change the cell to have red fill formatting?

I am also curious as to why you want to do this--there might be another way to approach your overall problem.

What conditional formatting are you using and what range(s) is it applied to?

Norie,
they are explained in my OP under my attached file and they are just simple "greater than", "less than" rules.

Are you sure the conditional formatting is what's slowing things up?

You've only applied it to 1138 cells, and the conditions are pretty simple.