Biff,

Thanks for the reply but that did not work. MIN formula highlights the
minimum of the percentages and it doesn't highlight what's closes to
100%. In this case it is 100.14. Please help with this. Thank you.


--
lacosta
------------------------------------------------------------------------
lacosta's Profile: http://www.excelforum.com/member.php...o&userid=15519
View this thread: http://www.excelforum.com/showthread...hreadid=476926