Conditional formatting based on the formula

I've attached a workbook with explanation inside there,

Main Goal is to do conditional formatting on the A & B columns.

Here is a formula based on Cell A:
=IF(RIGHT(A1,5)="396OL","101OL",IF(RIGHT(A1,5)="400OL","101OL",IF(RIGHT(A1,5)="413OL","103OL",RIGHT(A1,5))))

Thank you

Where does that formula come into it? I can't see it in your file.

Pete

Hi Pete,
Formula is not anywhere at the moment, if you copy & paste the formula into C1 and drag it down to C10 the results for A1 will appear.

But, the point is, I'd like to apply conditional formatting depending on the values of last 5 characters with this formula being applied for column A against column B

Column B is just original data I will be comparing to Column A depending on the last 5 characters.

Thanks

Anyone got any clues? Been stuck for a while

How about

Formula:

Please Login or Register  to view this content.

Perfection, could you explain this formula please? I understand a bit of it but not all. Also any recommendation where I can learn excel formulas and vba?

The formula is basically the same as yours, except I Added
=RIGHT($B1,5),$A1<>""
to the end, so if the result of your formula matches the last 5 digits in col B & col A isn't blank, then it highlights the cell