I have a spreadsheet that has several row with number value going across; I
only want to find the max in one column going down and if its the max number
I want to change the entire row to be say green for max or red for min. Ex:
A1 B1 C1 D1 E1
F1
A2 Voyager- Titanium $319 $50 $200 $200 $119
A3 Samsung Saga $400 $70 $270 $270 $130
A4 Palm Centro $284 $70 $120 $120 $164
A5 Blackberry Curve $366 $70 $150 $170 $196

F1 is the cell that I am wanting to find the max and have the entire row
change color based on the max value 196 in column F only. Does anyone know
how would enter this as a formua in the condition formula text box?