Can I change the formatting of a cell (currency) based on a different cell?

[bruty]

I have a column in my spreadsheet that is an invoice amount. The invoice can be received in either pounds or euros and this is written in the column next to it.

Is there any way for the display formatting to be changed automatically dependent on whether I write pounds or euros?

 

[Trevor G]

First format the column to currency then you can use Conditional Formatting to change the format based on cell content.

Excel Workbook
	D	E
2	pounds	2,345.00
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
E2	1. / Formula is =$D$2="euros"	Abc
E2	2. / Formula is ="$D$2=""Pounds"""	Abc

 

[bruty]

Excellent. Worked a treat.

Many thanks.

 

[Trevor G]

Happy to help and thanks for letting me know you have a solution.