Using MATCH formula for condtional formatting not working

[Delanos123]

Hi all

Perhaps someone can help me out by telling me what is wrong with my MATCH formula in conditional formatting OR if you think I should be using a different formula (IF) then great.
We have a list of staff and in one column the sheet shows their current payscale. Another column shows their payscale from last year.
If they have moved up the payscale I would like the current salary cell to go GREEN, if it has stayed the same it needs to go ORANGE and lower = RED.
As the salary points are not numeric I created a separate list of the scales in order of lowest to highest and then I put the following in conditional formatting....but its not working. Can you help me out with why?
The cells values are VLOOKUP results though - would this have an effect?

=MATCH(B2,scales!$A$2:$A$58,0) (more than)MATCH(A2,scales!$A$2:$A$58,0) select GREEN FILL
=MATCH(B2,scales!$A$2:$A$58,0) =MATCH(A2,scales!$A$2:$A$58,0) select ORANGE FILL
=MATCH(B2,scales!$A$2:$A$58,0) (lower than)MATCH(A2,scales!$A$2:$A$58,0) select RED FILL

I created it in my own spreadsheet to test it, then I went to my boss's spreadsheet which has various formula's on and tried to replicate it to no avail
Any help appreciated

[AliGW]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[Delanos123]

thanks
This is the very basic one that works
Im just going to get a copy of the spreadsheet that I cant do it on and do what you said and send it over to you
Give me 10-15 mins.

[Special-K]

Formulas look fine to me, do as AliGW said and upload a file so we can take a better look.

[AliGW]

Yes, please, because an example that works is not going to help!!!

[TMS]

Select all the columns starting with row 2 and use:

=MATCH($B2,Scales!$A$2:$A$58,0) > MATCH($A2,Scales!$A$2:$A$58,0)
=MATCH($B2,Scales!$A$2:$A$58,0) = MATCH($A2,Scales!$A$2:$A$58,0)
=MATCH($B2,Scales!$A$2:$A$58,0) < MATCH($A2,Scales!$A$2:$A$58,0)

Note the absolute column references.

[Delanos123]

Thanks so much
Im still trying to get hold of the relevant spreadsheet (boss in a meeting) as soon as I get it, Ill upload a copy (with info removed) and try this above
Thanks so so much - Ill come back ASAP

[TMS]

You need to change the Applies to Range to:

=$B$2:$B$8

in all cases and make sure your formula references row 2.

And delete all the repetitions.