| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Custom Format with different Criteria
I need to format a complete column of cells as below. I tried format Cell
Number Custom but accepts only two criteria, not all eight criteria listed below. [=1000] ####-"000";[<=9999] ####-"000"; [=10000] ####-"00"#;[<=99999] ####-"00"#; [=100000] ####-"0"##;[<=999999] ####-"0"##; [=1000000] ####-###;[<=9999999] ####-### Is there another solution? I am not familiar with coding, so if coding is the only solution please give me an appropriate one, Thanks and regards Santhosh Kuwait |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ignore auto format after applying a custom format?? | Excel Discussion (Misc queries) | |||
| Custom Cell format to mimic time format | Excel Discussion (Misc queries) | |||
| how do I add phone number format as a permanent custom format? | Excel Discussion (Misc queries) | |||
| Countif using format criteria not number criteria? | Excel Worksheet Functions | |||
| Countif using format criteria....not number criteria? | Excel Worksheet Functions | |||
Threaded Mode
