Cannot copy conditional formatting

  • Thread starter Thread starter light
  • Start date Start date
L

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
 
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
 
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
 
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
 
Back
Top