Copy>Special>Format: Not for Conditional Formatting?

[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?

Thanks

Ale

 

[Guest]

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

 

[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