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.