Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting Problem - Dynamic Formula?? GoBucks[_2_] Excel Worksheet Functions 2 May 3rd 09 04:33 AM
Applying conditional formatting to dynamic range Arup C[_2_] Excel Discussion (Misc queries) 1 October 17th 08 02:10 PM
Dynamic number formatting smaruzzi Excel Discussion (Misc queries) 2 May 21st 07 07:27 PM
Dynamic data formatting Suresh Excel Discussion (Misc queries) 1 July 3rd 06 01:51 PM
Conditional Formatting & Dynamic Range james Excel Worksheet Functions 2 October 11th 05 04:25 PM


All times are GMT +1. The time now is 11:58 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"