Conditional formatting being copied

S

Sandy

In cells A1:F1 numbers can be entered.
In cells A4:F4: conditional formatting exists in the form of
=A1<4 (colour the cell yellow) copied to F4.

There can be similar entries in A7:F7 (to those in A1:F1)
In cells A12:F12 there is conditional formatting again in the form
=A7<4(colour the cell yellow) again copied to F12.

The problem is that sometimes the entries in
A4:F4 are identical to those in A12:F12, in which case
some users copy these entries to A12:F12, resulting in
the conditional formatting being copied down and therefore
messed up.

I have simplified the actual ranges involved, they are much more
extensive in actuality.

How can I prevent the copying of the conditional
formatting taking place from row 7 to row 12?
I don't mind the data being copied.

Sandy
 
R

Roger Govier

Hi Sandy

Use Copy>paste Special>Values
then the formatting won't get copied
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top