Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Number format of ranges using cell value
I have 6 named ranges (RangeX, RangeY, Etc)
I would like to format each range using a value in a cell (cell1, Cell2, ....Cell6) For instance if cell1.value = 2 (meaning 2 decimal places) then format of RangeX = "0.00" I can write this separetely for each range but this is long and tedious. is there a clever way to loop through this? I tried but failed. Any idea? -- caroline |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
format cell custom Number format | Excel Worksheet Functions | |||
Format Cell/Number | Excel Discussion (Misc queries) | |||
Format a cell with a custom number format | Excel Worksheet Functions | |||
Number format based on number format of another cell in another workbook | Excel Programming | |||
Conditional format cell ranges with loop? | Excel Programming |