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
"Ingeniero1" wrote:
Using Excel 2000
Table with six columns, 36 rows: need to highlight the cell with the
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 rows
(CopySpecialFormat) but it doesn't work.
Will I have to CF each row individually?
Thanks
Alex
--
Ingeniero1
------------------------------------------------------------------------
Ingeniero1's Profile: http://www.excelforum.com/member.php...fo&userid=4029
View this thread: http://www.excelforum.com/showthread...hreadid=528522