Excel Conditional Formatting

Stompa

You may want to trawl through this lot:

https://www.google.co.uk/search?q=Excel+"conditional+formatting"+"insert+row"+splitting+range

stevemcol

Jack. I've re-produced your problem and see what you mean.
If you first insert an empty row (that recreates the conditional format correctly), then paste 'forumlas' without formatting, it seems to work, if I've understood your issue.

[Deleted User]

stevemcol wrote: »

Jack. I've re-produced your problem and see what you mean.
If you first insert an empty row (that recreates the conditional format correctly), then paste 'forumlas' without formatting, it seems to work, if I've understood your issue.

If I click the paste clipboard icon I get a list of options, at the top of which is a block of eight. Second from left on the top row is one marked "fx" with a pop up saying "Formulas (F)". If I use that I still get the same problem. (Excel 2010)

Edit: Just realised what happened above. The correct copy appeared when I hovered the pointer, and when I clicked the icon. It went wrong after I pressed the return key to get rid of the shimmering select range outlne. So that raises another question: how do you get rid of the shimmering box when you've pasted all the copies you need? (Without pressing the return key.)

stevemcol

The shimmering box has always annoyed me. No doubt someone will have a better answer (ie a correct answer!) but I just go elsewhere on the sheet and paste an empty cell into another empty cell.

Does it work then?

Cornucopia

jack_pott wrote: »

So that raises another question: how do you get rid of the shimmering box when you've pasted all the copies you need? (Without pressing the return key.)

Press the "Esc" (Escape) key?

stevemcol

Cornucopia wrote: »

Press the "Esc" (Escape) key?

lol. how daft do i feel?!

[Deleted User]

Cornucopia wrote: »

Press the "Esc" (Escape) key?

That bit was worth starting the thread all on it's own. Seem to have got it cracked now, thanks all.

Cornucopia

Happy to help