Conditional Formating and Mid
 

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

Conditional Formating and Mid
 

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

Conditional Formating and Mid
 

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