Hello All,

I need help with the following. I need Excel to highlight the closest
number to 100% in column C(Act. Price). At the same time once it finds
the closest thing in column C it need to highlight everything accross.
In this case the closest this to 100% is 100.14 therefore 8, 5.625% and
100.14% should be highlighted.

Thanks.


A B C
Rank Rate Act. Price
15 6.500% 103.95%
14 6.375% 103.21%
13 6.250% 102.48%
12 6.250% 102.48%
11 6.000% 101.94%
10 5.875% 101.18%
9 5.750% 100.43%
8 5.625% 100.14%
7 5.500% 99.50%
6 5.375% 98.72%
5 5.250% 97.40%


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