??? Copy conditional formating

[Guest]

I do not know how to copy conditional formating down to additional rows

Col A is Text
Col B,D,F,H,J,L are numeric descriptions (every other column)
Col C,E,G,I,K,M are columns which i need to hightlight the Max number

I'm using =C7=MAX($C$7,$E$7,$G$7,$I$7,$K$7,$M$7)

This highlights the Max number, but I can't copy it down to additional rows

Any answers?

 

[maxsgroi]

I do not know how to copy conditional formating down to additional rows

Col A is Text
Col B,D,F,H,J,L are numeric descriptions (every other column)
Col C,E,G,I,K,M are columns which i need to hightlight the Max number

I'm using =C7=MAX($C$7,$E$7,$G$7,$I$7,$K$7,$M$7)

This highlights the Max number, but I can't copy it down to additional rows

Any answers?

You can try removing $ just before the row index:

=C7=MAX($C7;$E7;$G7;$I7;$K7;$M7)

Then you can copy it down

Hope it helps
Max

 

[Guest]

Max,

Thanks so much, that worked. What I don't understand is why I would have
"$C7 and remove the $ sign on the row.

Many thanks,

Bob

 

[Gord Dibben]

So that the 7 in $C7 will increment to 8, 9, 10 etc. as you copy down.

See help on Absolute and Relative cell referencing.


Gord Dibben MS Excel MVP

 

[Guest]

Gord,

Thanks very much. Very good explanation.

Bob