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: 312

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

Related posts about microsoft-excel

Related posts about excel-2007