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:
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):
Bookmarks