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!
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!