Forum Discussion
Solved
Formatting a number by reference
I have a column consisting of all data validation drop downs. Clicking on the arrow gives you 5 choices and these are all currency format option - USA, CAN, HDK etc. Next to that column are where t...
Rissky1 You can do this if you create a conditional formatting rule and a corresponding custom number format for each currency format you want.
So conditional formatting -> custom formula would be =(A3="CAN") and in the Format... you click "Custom" and "Type": "CAD" $0
Repeat the above for each of the other currencies.
Rissky1 You can do this if you create a conditional formatting rule and a corresponding custom number format for each currency format you want.
So conditional formatting -> custom formula would be =(A3="CAN") and in the Format... you click "Custom" and "Type": "CAD" $0
Repeat the above for each of the other currencies.
