![]() |
|
#4
|
|||
|
|||
|
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. |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Conditional Formatting if certain cell meet certain conditions
|
bbutl027 | Excel | 1 | 11-25-2016 12:52 AM |
Looping through word and writing to excel when certain conditions are met
|
Irene H | Word VBA | 2 | 07-10-2016 05:59 PM |
| Excel Formula for Multiple Conditions & Results | nowco | Excel | 4 | 03-16-2016 11:24 AM |
| Excel-Save Custom Formatting | CarlaK | Excel | 1 | 10-18-2013 05:05 PM |
| Embedded Excel Graphs - Custom Formatting | Cody | Drawing and Graphics | 0 | 07-02-2010 02:30 PM |