If instead of reading this I sort of cast my eyes
over it in a diffused and unfocused mode, I get the
impression that you want to identify the max and
min values in E, and highlight the entire
corresponding rows in a particular color.

If so, I'd set aside two helping cells and two helping
columns. One helping cell (let's say it's in F1) is
=MAX(E), the other (in G1) is =MIN(E). In the two
helping columns F and G are =E2=F$1 and
=E2=G$1. Thus columns F and G are full of mostly
FALSE and a few TRUE values. Fn is TRUE if that
row has the largest value of E; Gn is TRUE if the
row has the smallest.

Now use conditional formatting to color green the row
where Fn is TRUE, and color red the row where Gn is
true. Write back if you have questions or don't know
what conditional formatting is.

--- "SunshineinFt.Myers" wrote:
Max numbers are in ending column say E1, E2 etc,
but I do have numbers in all other cells that are
higher numbers then what is in cell E1 but I do not
want to find their max or min value: A1, B1, A2, B2,
going down but do not want to count them. Only
want to highlight the entire row that has the ending
Max and ending low with the colors green and red
being low.