MAX Value based on Criteria Conditional Formatting

[Truiz]

I may be trying to accomplish something fairly easy in a to complicated way, but here is my struggle...

I have a table with Sales data, kinda like this

	A	B	C	D	E
1	ID	Sales Rep	Info	Info	Sales
2	001	Tony	Stuff1	Stuff2	1564
3	002	Mike	Stuff3	Stuff4	8645
4	003	Tony	Stuff5	Stuff6	18956421
5	004	Mike	Stuff7	Stuff8	486
6	005	Tony	Stuff9	Stuff10	486
7	006	Mike	Stuff11	Stuff12	51468543
8	007	Tony	Stuff13	Stuff14	68421
9	008	Mike	Stuff15	Stuff16	6543
10	009	Tony	Stuff17	Stuff18	8
11	010	Mike	Stuff19	Stuff20	685463
12	011	Tony	Stuff21	Stuff22	5846
13	012	Mike	Stuff23	Stuff24	614683
14	013	Tony	Stuff25	Stuff26	152165
15	014	Mike	Stuff27	Stuff28	13516
16	015	Tony	Stuff29	Stuff30	13652

<colgroup><col style="******* 25pxpx"><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Hoja1​

Next to it I have a Data validation list to select the rep I want to highlight so I select from the drop down mike and all the rows with mike get highlighted but now I also want to highlight Mike's MAx and Min Sales Value and of course replicate for Tony... I honestly have cero clue how to do that

 

[AhoyNC]

See attached link.
https://www.youtube.com/watch?v=zNx585Sl1JQ&list=PL2ACA26D4485F8EDD&index=3

 

[Truiz]

Can't watch videos in the office, website is blocked.

 

[AhoyNC]

Here is the formula that came from the link (He does a good job in explaining the formula).

Excel Workbook
	A	B	C	D	E
1	ID	Sales Rep	Info	Info	Sales
2	1	Tony	Stuff1	Stuff2	1564
3	2	Mike	Stuff3	Stuff4	8645
4	3	Tony	Stuff5	Stuff6	18956421
5	4	Mike	Stuff7	Stuff8	486
6	5	Tony	Stuff9	Stuff10	486
7	6	Mike	Stuff11	Stuff12	51468543
8	7	Tony	Stuff13	Stuff14	68421
9	8	Mike	Stuff15	Stuff16	6543
10	9	Tony	Stuff17	Stuff18	8
11	10	Mike	Stuff19	Stuff20	685463
12	11	Tony	Stuff21	Stuff22	5846
13	12	Mike	Stuff23	Stuff24	614683
14	13	Tony	Stuff25	Stuff26	152165
15	14	Mike	Stuff27	Stuff28	13516
16	15	Tony	Stuff29	Stuff30	13652
Sheet

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2	1. / Formula is =AND($B2=$G$1,MAX(IF($B$2:$B$16=$G$1,$E$2:$E$16))=$E2)	Abc
A2	2. / Formula is =AND($B2=$G$1,MIN(IF($B$2:$B$16=$G$1,$E$2:$E$16))=$E2)	Abc