I solved it myself. Basically I went through the entire workbook and made sure there is no double up in any of the conditional formatting rules. Now when I copy and paste the rule doesn't duplicate any longer.
My file was soooo slow before and now runs like a charm. I had tons of duplicate rules in there which killed the file.
Thanks anyway.
Bookmarks