"robert morris" wrote:
.. Any thoughts on highlighting the five highest or lowest?

To format 5 lowest:
Select the desired range for conditional formatting, say select G10:Y15
(with G10 active), then apply CF using the formula:
=ISNUMBER(MATCH(G10,SMALL($G10:$Y10,COLUMN($A:$E)) ,0))
Format to taste, Ok out

To format the 5 highest, use:
=ISNUMBER(MATCH(G10,LARGE($G10:$Y10,COLUMN($A:$E)) ,0))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---