Pasting Conditional Format into a Range
Posted on 2014-08-28
I'm having a very weird problem in Excel pasting Conditional Formats. I have a conditional format in cell B2. If I copy and paste it into cell B3, it works fine. But if I copy B2 and paste it into a RANGE (say, B3 - B10) ALL cells from B4-B10 pick up the B3 conditional format, instead of each pasted cell picking up the correct references. These conditional formats involve Vlookups. But if one cell can paste to another, I don't get why it can't paste to a range.
Any assistance appreciated.