Conditional formatting to highlight the lowest valid value

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

PaladinWhite - 26 Mar 2008 00:29 GMT

Cell A1 contains a "critical value". I want to format the range B1:B5 so that
one cell is highlighted - the cell with the value closest to, but not greater
than, A1.

E.g. if B1:B5 looks like this:

ColB
3
9 <--- This should be highlighted when A1 = 14
16 <--- This should be highlighted when A1 = 16
58 <--- This should be highlighted when A1 = 30
100

Thanks.

Reply to this Message

PaladinWhite - 26 Mar 2008 00:35 GMT

Nevermind this post; I figured it out. I could swear I had tried this formula
and it didn't work... I must have mistyped.

=ROW()=MATCH($A$1,$B$1:$B$5)

> Cell A1 contains a "critical value". I want to format the range B1:B5 so that
> one cell is highlighted - the cell with the value closest to, but not greater
[quoted text clipped - 10 lines]
>
> Thanks.

Reply to this Message