Search a cell and match numbers in another cell.

[yzahjh]

Hi i'm wondering if in cell B2 it contained the numbers 31,23,4,5,6,11,7 and in cell A1 it contained the 31,23,6,42,3,15. is it possible for me then to have a formula thats looks in cell B2 to see if they're are any matches in A2 and if there are any, i would like the font on the matched numbers to change colour in cell A2.....for example the numbers: 31,23 and 6.

[Pete_UK]

You can't do that with a formula - you would need a macro.

Hope this helps.

Pete