Copy conditional fomats..help please

[Terry]

Win98SE
'Office XP Professional

I have a spreadsheet for recording scores weekly, so when I have entered all
the scores in one column, the highest score/s (MAX) are colored.
Each Column has many cells, over 7 months.
I am using cond' formatting to color generate the MAX score in each col.
The cond' f'mat is: A4=MAX($A$4:$A$58)
Part relative, part absolute..
The scores are not the problem...it is the cond' f'matting.

My problem is the time consuming task of copying the cond' f'mat (using
painter)......the whole column into the next column.
When I use painter tool to mass coppy (double click painter symbol), I still
have to correct the absolute cells, to show column $B$ for example.
Is there a quicker/auto method I could use please?

TIA

 

[Biff]

Hi Terry!

Try this:

change the formula to:

=A4=MAX(A$4:A$58)

Now, to copy the conditional formatting select the range
A4:A58.
Right click and select copy.
Select the range to copy to. I'll assume it's the next
column, B4:B58.
Right click and select Paste Special>Formats.
OK out

Biff

 

[Terry]

Biff

Thanks...works a treat.

Terry