If the range were A1:A500, select A1, then in the name box on the top left
enter A1:A500, select 'Formula is' in Conditional Formatting and enter the
formula :-
=A1=MAX($A$1:$A$500)
Regards,
Alan.
"Excelicious" wrote in message
...
So I have successfully condition cells to highlight Max and Min. The
problem
I am having is copying my formating to reference the same values on
different
ID numbers. So when I copy the conditional formating for ID 1 and try to
copy
the conditonal formating to ID 2 the conditional formating still refers to
ID
1 cell range. I have placed $ before the cell locations. Pretty
frustrating
so any Excel masters to help since I have 500 IDs and would hate to have
to
indiviudally update each row.


ID Value 1 Value 2 Value 3 Value 4
1 500 600 400 550
2
3
4
5
6






--
Yeah that about sums it up.