Quote:
Originally Posted by xor
Select the cell(s) to format, Conditional Formatting, New Rule, Use a formula to determine which cells to Format. In the New Formatting Rule dialog in the field Format values where this formula is true, you write:
=$A$1>9999999999999
Press Format. In the Format cells dialog select the Number tab. Under Category select Custom and in the field Type, write "("###")" ###-#### ####. OK you out. Then in the Conditional Formatting Rules Manager press New Rule and repeat the process with next condition ($A$1>999999999999) and so on. Be aware that Excel cannot handle more than 15 digits as numbers.
|
Thanks, primary issue here now is that I'm not sure how to manage priority. If I set up 5 conditions (10 digit number, no extension; 11 digit number, 1 digit extension; 12 digit number, 2 digit extension; 13 digit number, 3 digit extension; 14 digit number, 4 digit extension; ) how do I stop multiple matches from happening?
I.E. 15, 14, 13, and 12 digits are all greater than 10 digits, so a greater than 10 digits for a 1-digit extension will run into issues.