Hi!

It works for me.

Want to see a sample file where it works? Just let me know where to send it.

Biff

"lacosta" wrote in
message ...

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