Conditional Formating copying (Max Min)
 

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.

Conditional Formating copying (Max Min)
 

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.

Conditional Formating copying (Max Min)
 

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!

--
Yeah that about sums it up.


"Alan" wrote:

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.

Conditional Formating copying (Max Min)
 

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.
"Excelicious" wrote in message
...
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!

--
Yeah that about sums it up.


"Alan" wrote:

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.