Select your range condiditional Formatting
Condition1: =$A$1="GBP"
Format as Number Currency Symbol: select Eng (US)

Condition2: =$A$1="USD"
Format as Number Currency Symbol: select Eng (Uk)


"diacci1st" wrote:

Hi
I need to formay a range of cells as per example below:

if A1=USD then B10:B13 format as $
if A1=GBP then B10:B13 Format as £

and so on..
How can I do this automatically as a kind of "conditional formatting"?
Thank you
AD