Conditional formation between column A or B based on which is closer to C

[cody.starr]

so i have a work sheet filled with data. Im trying to figure which data in cells B1 and C1 is closest to A1 how do i conditional format if my list goes all the way down to A250?

[NBVC]

Select cells B1:C250 and go to Home|Conditional Formatting>New Rule

Select "Use a formula to determine which cells to format" and enter formula:

=ABS(B1-$A1)=MIN(ABS(B1-$A1),ABS(C1-$A1))

Then go to Format and choose from the Fill tab.

[cody.starr]

This seems to work, but as im going through data it starts to highlight both data points even when one number is farther away than A1

[NBVC]

Watch the $ signs, that make the references absolute... are you changing those?