CopySpecialFormat: Not for Conditional Formatting?
 

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?:rolleyes:

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

CopySpecialFormat: Not for Conditional Formatting?
 

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?:rolleyes:

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

CopySpecialFormat: Not for Conditional Formatting?
 

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.


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=528522