T
TKrepitch
Worksheet 1 has a dropdown list that uses a lookup function to retrieve
data from Worksheet 2. There is one graph in Worksheet 1 that is based
on the numbers retrieved.
The problem we have is that the numbers in Worksheet 2 can be dollars
or percentages or numbers. The graph on Worksheet 1 will always
reflect the formatting that is in Worksheet 1, of course...so it needs
to be changed manually when the dropdown choice changes from a dollar
field to a percentage field, from number to dollar, etc.
I've tried conditional formatting, but I don't think you can use it
with Style. I've tried using the =dollar() function in a workaround,
but that isn't helpful without similar functions for percentage and
number.
Is there a good option here? Thanks!
data from Worksheet 2. There is one graph in Worksheet 1 that is based
on the numbers retrieved.
The problem we have is that the numbers in Worksheet 2 can be dollars
or percentages or numbers. The graph on Worksheet 1 will always
reflect the formatting that is in Worksheet 1, of course...so it needs
to be changed manually when the dropdown choice changes from a dollar
field to a percentage field, from number to dollar, etc.
I've tried conditional formatting, but I don't think you can use it
with Style. I've tried using the =dollar() function in a workaround,
but that isn't helpful without similar functions for percentage and
number.
Is there a good option here? Thanks!