Format cell based on other cell value

[mordrid]

Hi, I would like to automatically format a cell based on currency type for example if have a drop down list in A1 of Dollar, GBP, Euro and I select say Dollar I would like cell C1 to auto format to show dollar sign in front of the value, similarly if I select Euro I would like C1 to update to show Euro sign.

I have been trying IF statements but do not know how to say if .... format like....

Any help gratefully received

 

[JamesCanale]

MrExcelPlayground16.xlsx
	A	B	C
1	Euro		€ 45.12
2	Dollar
3	Pound
4	Euro
Sheet14

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C1	Expression	=A1="Euro"	text	NO
C1	Expression	=A1="Pound"	text	NO
C1	Expression	=A1="Dollar"	text	NO

Cells with Data Validation
Cell	Allow	Criteria
A1	List	=$A$2:$A$4

 

[mordrid]

MrExcelPlayground16.xlsx
	A	B	C
1	Euro		€ 45.12
2	Dollar
3	Pound
4	Euro
Sheet14

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C1	Expression	=A1="Euro"	text	NO
C1	Expression	=A1="Pound"	text	NO
C1	Expression	=A1="Dollar"	text	NO

Cells with Data Validation
Cell	Allow	Criteria
A1	List	=$A$2:$A$4

View attachment 89605

Thank you worked a treat