Conditional Formating and Mid

[Wanna Learn]

Hello This is my conditional formatting formula =MID(B9,3,2=19) and it
does not work. column B has numbers such as 2D1985. what I want to do is
if the number 19 appears after the first two digits(in this case 2D) to
highlight the cell in grey. thank you

 

[Alan]

Try
=MID(B9,3,2)*1=19
Regards,
Alan.

 

[RagDyeR]

Try this:

=MID(B9,3,2)="19"
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


Hello This is my conditional formatting formula =MID(B9,3,2=19) and it
does not work. column B has numbers such as 2D1985. what I want to do is
if the number 19 appears after the first two digits(in this case 2D) to
highlight the cell in grey. thank you