Conditional Formating copying (Max Min)

[Excelicious]

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

 

[Alan]

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]

Thank You Alan. However I still am having a problem where my cell reference
is still referencing my ($D$3:$J3$) when I copy the formating. When I look
at formating for rows 5-100 they also are still referencing ($D$3:$J3$).


(Row 3) =D3=MIN($D$3:$J$3) <<-- (actual formula used in conditional format)
(Row 4) =D4=MIN($D$3:$J$3)
(Row 5) =D5=MIN($D$3:$J$3)

Not good. Please help!

 

[Alan]

Same as the ranking issue, you can't mix rows and columns. If your looking
for the MIN in D$3:$J$3 you need to test D3, E3, F3 etc, not D3, D4 ...
Regards,
Alan.