Conditional formatting if a number starts with specific digits

[vshukla]

I am trying to apply condtional formatting to highlight the cells in D column if it starts with 91099 or 91004.
I tried to do the same using wild card, and left function but didn't get the desired output.
Can somebody help me out?

Thanks in advance

[Fotis1991]

Try

Please Login or Register  to view this content.

[martindwilson]

=LEFT(D3,5)="91004" or for both
=OR(LEFT(D3,5)="91004",LEFT(D3,5)="91099")

[vshukla]

Thanks Fotis. It really worked.

I also tried doing it but without adding "0" so it wasn't working. So can you please tell me logic behind adding "0".

[martindwilson]

you either do it with real numbers by adding 0 or you use text as i showed text "99999" plus 0 =real number 99999

[Fotis1991]

When you use the functions LEFT, MID, RIGHT, Excel get these values as Text. So you need to convert in numbers adding a zro(0).

[vshukla]

Thanks Fotis

[Fotis1991]

You are welcome and thanks for the feedback & rep.