Conditional Format

[mssbass]

I have 3 rows with formulas that result in either a positive or negative percentage
I want to highlight the cell in each column for the number that is closest to zero in light green

 

[Joe4]

Let's say that the three values you are comparing are A1:A3.
Then, select A1:A3, and apply this Conditional Formatting formula:

=abs(a1)=min(abs(a$1:a$3))

and choose your light green formatting option.

 

[mssbass]

For some reason, I cannot get this to work. I even tried opening a clean separate worksheet and cannot get the formatting to apply.

 

[philwojo]

What are your formulas, are you sure they are returning values and not text?

 

[Joe4]

What are your formulas, are you sure they are returning values and not text?

This is a good point.

If you are using something like the "TEXT" function in the formula to return the percent sign, this will cause the result to be Text and not Numeric, and it won't work.
You don't want to use the TEXT function. You can simply use custom formatting to return the percent sign.

If that does not solve it, please post your formulas, and and example that is not working.

 

[mssbass]

Now it's working - probably a bug or something. I appreciate your help!