Basically, I have a set of values being graphed. The values change depending on the buttons that have been toggled. Sometimes the values are revenue numbers and sometimes they are sales volume numbers. The cell next to the values is a header like "Revenue (MM USD)" and changes to "Volume (000s Units)" when volume is toggled.
I'd like to make the cells display in number formatting when volume is toggled and as currency when revenue is toggled.
Any help would be greatly appreciated. I apologize if I didn't include any important information, but I'll be quick to respond to any inquiries.
Thanks
Bookmarks