| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested If statement to control format of number-type cells
The conditional formatting in Excel doesn't seem to allow for numeric
formatting. I need to control the formatting of numeric cells as shown below- Please help. 0.00# = 4 decimals 0.0# = 3 decimals 0.## = 2 decimals 1 to 9.99 = 2 decimals 10 to 99.9 = 1 decimal 100 plus = no decimals -- TB |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| format control on large number of checkboxes | Excel Worksheet Functions | |||
| Format Control on large number of check boxes | Excel Worksheet Functions | |||
| format control for large number of check boxes | Excel Worksheet Functions | |||
| Excel Format Cells - Number Tab - Custom - Order of Type Window. | Excel Discussion (Misc queries) | |||
| Adding new 'Type' to Format->Number->Time->Type | Excel Discussion (Misc queries) | |||
Threaded Mode
