Compare one cell to two sets of cells in a table - and add in conditional formatting!

Hello everyone,

I wonder if anybody can help me, please?

I need to compare the value of a cell to see if it lies between the value of two other cells in a table, then if it does, to compare the last two digits of that number to see if they lie between two other values in two other cells, in the same table. A conditional format would be helpful to confirm/deny that the last two digits lie within the limits of the 3rd and 4th columns

For example, if I have the number 41256 I can see that it is between the two columns of the second line, and the last two digits are between the last two columns of the second line. I've tried to show columns in my example, as best I can!

38000 - 39999 | 53 - 60
40000 - 41999 | 52 - 61
42000 - 43999 | 51 - 61
44000 - 45999 | 50 - 62
46000 - 47999 | 50 - 63

For the life of me, I cannot see how to get this to work. Any ideas anybody?

Thanks in advance!

Hello Special K,

Thanks for your input. I understand that the formula is for conditional formatting, but cannot see see how it will help to compare anything other than that single instance.
Just FYI, I have the data above in a defined-name table, called Test.

Here's a link to a small sample of data with your instructions carried out, although not showing correctly.

Thanks again!

Duffgen