??? Copy conditional formating
 

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?

??? Copy conditional formating
 

On 7 Mag, 21:29, robert morris
wrote:
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

??? Copy conditional formating
 

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

" wrote:

On 7 Mag, 21:29, robert morris
wrote:
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

??? Copy conditional formating
 

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

On Mon, 7 May 2007 13:14:00 -0700, robert morris
wrote:

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

" wrote:

On 7 Mag, 21:29, robert morris
wrote:
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

??? Copy conditional formating
 

Gord,

Thanks very much. Very good explanation.

Bob


"Gord Dibben" wrote:

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

On Mon, 7 May 2007 13:14:00 -0700, robert morris
wrote:

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

" wrote:

On 7 Mag, 21:29, robert morris
wrote:
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