View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Wanna Learn Wanna Learn is offline
external usenet poster
 
Posts: 318
Default 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