Formatting

[Claire$]

Hey people,

I have three very extensive columns of data. I want to somehow identify figures in column A that fall between figures adjacent to one another in columns B and C and I'm having trouble. I thought my best bet would be to conditionally format the data and then sort it by that but I can only seem to do that when all the values are on the same row.
Can anyone help?

To illustrate what I mean in case that wasn't clear, here is an example
A B C
12 10 20
7 32 33
50 25 37
19 79 94
28 100 150
So if this was my data, then I would want to identify 12 (between 10 and 20), 19 (between 10 and 20) and 28 (between 25 and 37)


Thanks a lot!

-C

[Kyle123]

use a helper column with the formula

=IF(AND(A1>=B1,A1<=C1),1,0) 

Then filter on 1

[Bob Phillips]

Use conditional formatting with a formula of

=ISNUMBER(SUM(MATCH(1,(A1>=$B$1:$B$5)*(A1<=$C$1:$C$5),0)))

[Claire$]

Thanks guys! Mad skills