I should have included in my first post that cell P1 is a drop down with the 1 to 9 numbers, and when I select a number in P1 it is a single digit from 1 to 9, then all the same numbers as P1 in the E2:M10 range are bold and font size 14.

So the Target is range P1.

Hi Claus,

I think I am still misleading you with bad directions.

Here is a sample column of nine the columns in the OneRng.

1367
167
4
139
1379
1489
2
135
8


If P1 = 4 then the single 4 and the 4 in 1489 should both be bold and font 14.

It is only affecting the lone digit 4 as written.

Howard