Hi,

This can't be done in 2003 or earlier without VBA. In 2007, if the range
you want to format is A1:A100 and you are entering 1 in cell B1 then:

1. Select the cells A1:A100 and choose Home, Conditional Formatting, Manage
Rules, New Rule
2. Choose Use a formula to determine which cell to format
3. In the Format values where this formula is true enter the following
formula:
=$B$1=1
5. Click the Format button and choose the Number tab, Currency, and pick USD
from the Symbol list
6. Click OK twice
7. Repeat for each currency conditon you want to use.

If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"Yossy" wrote:

Please how can I automatically format the following. Where the following
amount are entered in a cell it should change to respective Currency format.
if I enter 1.000 it should automatically change to USD.

1.000 = USD
0.893 = CAD
1.975 = GBP
1.3440 = EUR
0.754 = CHK

All help totally appreciated.Thanks for your assistance