Conditional Formating and Mid

W

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
 
R

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
 
Top