Conditional formatting being copied

[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

 

[Roger Govier]

Hi Sandy

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

 

[muddan madhu]

conditional format for A4:F4

=IF(ROW()=4,A$1:F$1<4,A$7:F$7<4)

 

[Sandy]

Hi Roger
Yes that is what I do - sadly some other users don't.
Thanks
Sandy

 

[Sandy]

Hi Muddan
Very simple and very clever and ideal for my situation.
Thanks
Sandy