Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
dynamic formatting of cells
Hi all,
I have a workbook that contains a data page and a report page. The report page is generated by a combobox on the data page which basically lets the user pick a financial indicator from a list. When the indicator is selected, the report fills with the #'s for that indicator. However, each indicator has a different # format, i.e. I have $, % and 2 decimal # formats). I would like the report page to have the # format of the indicator selected on the data worksheet. Is there a simple way to accomplish this? TIA *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Problem - Dynamic Formula?? | Excel Worksheet Functions | |||
Applying conditional formatting to dynamic range | Excel Discussion (Misc queries) | |||
Dynamic number formatting | Excel Discussion (Misc queries) | |||
Dynamic data formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting & Dynamic Range | Excel Worksheet Functions |