conditional formatting

Posted by Julie S on August 23, 2001 8:04 AM

I know how to do the conditional formatting, but I'm having
trouble with the formula:

The winning number is 18.03

Julie's bid is 17.00
Dave's bid is 17.50
Bill's bid is 17.50
Jerry's bid is 17.00
Paul's bid is 18.00

I want to highlight the person who is the closest (Paul)

Posted by IML on August 23, 2001 8:45 AM

Lets say your bid in A1
Names and bids are in A4:B8

Select your cell and change condition to formula is. Enter
=MIN(ABS($A$1-($B$4:$B$8)))=ABS($A$1-B4)
then select your format.
Go back into the formula box and hit enter while control and shift are depressed.
Now use the format painter to on your other cells.
This should highlight the closest bid(s) over or under (ie no "price is right" accounting).

good luck