conditional formatting in excel 2010
        Posted  
        
            by 
                bigMir
            
        on Super User
        
        See other posts from Super User
        
            or by bigMir
        
        
        
        Published on 2012-05-01T19:03:01Z
        Indexed on 
            2012/09/20
            9:42 UTC
        
        
        Read the original article
        Hit count: 385
        
I have some strange problem, after I've made switch from excel 2007 to excel 2010 I've started to receive duplicates of conditional formatting rules in excel. For example: I have conditional formatting which colors the cell when it detects that cell contains a word "hello". When I copy this cell to other cells (which also contains the same rule) sometimes I receive duplicates. Those duplicates really slows down excel. So my question is: is there any possiblity to disable copy/paste of conditional formatting (I want to copy/paste all content excep conditional formatting, all formulas values and other stuff). P.S. Just to make it clear, I don't know how to reporduce that problem, it occurs sometimes and I work with excel a lot
© Super User or respective owner