Hi All,

I am using some code to do conditional formattting (since I have more that three conditions and that's all condiitonal formatting will allow). The problem is that whenevr I try to paste multiple cells of data, the formatting does not work. Initially I had a problem deleting multiple cells (runtime error), which is why I have the line:

Please Login or Register  to view this content.
But now, I need to also be able to paste multiple rows and columns of data and still have the formatting work. Any ideas? Here is the code (BTW, I apply this formatting to several columns, but to save space, I have only included the code for 1 column here):

Please Login or Register  to view this content.