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

Try
=MID(B9,3,2)*1=19
Regards,
Alan.
"Wanna Learn" wrote in message
...
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

Try this:

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

HTH,

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


"Wanna Learn" wrote in message
...
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