Quote Originally Posted by ammartino44 View Post
great. Thanks. Both of these worked. But i tried to put it in conditional formatting and it didn't work. Why is this?

Edit: Also, what should i do if there is a blank cell. I would like these cells to return false.

Thanks
=if(a1="",false,iserror(mid(a1,8,1)+0))