Yes

if left("1234567ab",9) = A1

if right("a12345",6) = A2

"franciz" wrote:

Hi

Is it possible to highlight these datas in a sheet using conditional
formatting as :

10000000 as red, and
1234567ab ( there might be 1 or 2 alpha after the numbers) as blue, and
a12345 ( there might be 1 or 2 alpha in front of the numbers as green.

thanks