Cannot copy conditional formatting

[light]

After highlighting 4 columns and a variable number of rows,I use thi
formula to give me the 3 highest values in each of the 4 columns(whic
turn pink) under conditional formatting:

Formula is: =C6>=Large(C$6:C$15,3)

IF I copy the formatted area with format painter and go to highlight
columns of data and a different or same number of rows(it doesn'
matter) at C17 the formula looks like this in the new formatted area:

Formula is: =C17>=Large(C$6:C$15,3)

I have to manually go in an change the incorrect range in parenthesis
If I change the formula and remove the $ signs the desired result doe
not work(i.E. will not give me the 3 highest values in eac
column)Putting the $ to the left of the letter does not work either.

Is there a way to copy this formula so it changes to the new range an
achieves the desired result

 

[Frank Kabel]

Hi
with which range do you want to compare C17 (as this is not included in
your range C6:C15). That is what is your expected result after copying
the format

 

[light]

Frank

In the first example I highlight C6:F15. Then I write the formula:

Formula is: =C6>=Large(C$6:C$15,3) in conditional formatting.

Now if I go to C17 with the format painter,after copying it from rang
C6:F15 I will highlight C17:F34 and let go of the mouse button. I ca
see the result is incorrect(top 3 values in columns C,D,E,and F are no
highlighted in pink,in that range C17:F34. It's all mixed up).When
check the formula in conditional formatting for C17:F34 , I find th
range in parenthesis has not changed relatively.I get :

Formula is: =C17>=Large(C$6:C$15,3) What I would like it to say and
manually change it to is:

=C17>=Large(C$17:C$34,3

 

[Frank Kabel]

Hi
not really possible to copy the formula this way. Though you may be
able to create for this specific instance a formula with OFFSET this
won't work if you highlight different numbers of rows. So I think
you'll have to change the formulas manually. sorry to say