Copy>Special>Format: Not for Conditional Formatting?

I

Ingeniero1

Using Excel 2000
Table with six columns, 36 rows: need to highlight the cell with th
largest value in each row.

This Conditional Format works fine: [If Equal] [=Max(Row Range)
[Bold/Green] :)

I did it for one row and tried to copy it to other row
(Copy>Special>Format) but it doesn't work.

Will I have to CF each row individually?:rolleyes:

Thanks

Ale
 
D

Duke Carey

Does your initial Row Range use absolute references? The only $s in the
address should be in front of the column references, not the rows, so this is
bad

$a$1:$f$1

while this is OK

$a1:$f1
 
J

John James

For illustration purposes, I'll assume the range is A1:F36
Use "cell value is" and change the formula to:
=MAX($A1:$F1). Do the rest the same
 
Top