Currency conditional formatting

Y

Yossy

I have some columns that I want to format currency based on currency figures
in the column cells. Lets say Cell A2 = 1, B2 = 1.30, cell D2= 1.7

How do I make these figures be conditionally formatted so that cell A2 can
be = USD 1.00, cell B2 = EUR 1.30 and Cell D2 = GBP 1.7 - Where USD = 1.00,
Eur = 1.30, GBP = 1.7. I use Excel 2007.

All help totally appreciated. Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top