Odd and even number with conditional formatting

[snekkis]

Please, can someone help me with this one:

I have a cell containing a 11 digit number. I would like to give another cell a conditional formatting based upon the 3rd digit from the right in this 11 digit number, or 9th from the left if you like. The formatting should be one for odd number, and one formatting for the even.

Thanks!

 

[Peter_SSs]

So, further to what emukiss10 has said, perhaps they should be:

=ERPARTALL(DELTEKST(A2;9;1))
=ERODDE(DELTEKST(A2;9;1))

 

[snekkis]

Two things:

First you have applied the formatting to the whole of column B, so you have to use A1 in the formula, not A2.
Second, the formula is testing the last three digits, not just the third to last digit.

I'm using the

 [COLOR=#333333][FONT=Arial]=ISODD(MID(A2,9,1))

and

 [/FONT][/COLOR][COLOR=#333333][FONT=Arial]=ISEVEN(MID(A2,9,1))[/FONT][/COLOR]

translated in Norwegian in the new attached file, and it seems to work, but it is only formatting ISEVEN in this file. Only green color shows. The ISODD formula should show red, to my understanding, but it is not.

https://drive.google.com/file/d/0Bxz42nal2vNjalFCZ3lFQ1VZc3BaWmsxOXVicjZnNDdOa0Rz/view?usp=sharing

 

[RoryA]

Your ISODD formula is spelled wrong. I think it should be ERODDETALL rather than ERODDETALLL.

 

[snekkis]

Your ISODD formula is spelled wrong. I think it should be ERODDETALL rather than ERODDETALLL.

Yes, that was it.

Thanks for the help, all of you.

 

[emukiss10]

Yes, that was it.

Thanks for the help, all of you.

Glad to help.