highlighting numbers in tens position

[rzml]

Hi,
looking for a vba code that will highlight the numbers in a range of cells containing 3,4,8 or 9 in the Tens position.
Thanks for the help.

 

[rzml]

Actually, a slightly easier to follow formula, the position is set by the division part of the formula
ones (see note below)

=SEARCH(MOD(INT(M2/1),10),"3489")

tens

=SEARCH(MOD(INT(M2/10),10),"3489")

hundreds

=SEARCH(MOD(INT(M2/100),10),"3489")

Note that INT and the division part are not necessary for the ones formula but I've left them in so that it is easier to follow. This one could be changed to

=SEARCH(MOD(M2,1),"3489")

and it would still work the same.

Thanks you very much. Appreciate your help. Thanks again