I have an issue with number formatting. Conditional formatting does not seem to handle this problem. I want my cells to display $ sign whenever certain condition is met or to display regular number formatting when that condition is not met.
Here is a simple example:
I have data in cells A1:A10, cell B1 controls formatting for that data. If I have number "1" in cell B1 then I want my numbers in cells A1:A10 to have $ signs in front of them (currency format), and if i have "2" in cell B1 then i want numbers to be in regular number format.
Maybe there is a macro i can use here? I tried conditional formatting and it is not working for number formats (I can change cell colors, bold text etc with conditional formatting but it is not working for number formats).
Here is a simple example:
I have data in cells A1:A10, cell B1 controls formatting for that data. If I have number "1" in cell B1 then I want my numbers in cells A1:A10 to have $ signs in front of them (currency format), and if i have "2" in cell B1 then i want numbers to be in regular number format.
Maybe there is a macro i can use here? I tried conditional formatting and it is not working for number formats (I can change cell colors, bold text etc with conditional formatting but it is not working for number formats).