Conditional formatting - currency?

[emailus]

I use Excel 2004 for Mac.

I am trying to set things up such that if a certain condition is met
in, say, cell A1, then that condition will determine the currency
format in, say, cell A2.

Hunting around the help files, I found some information on Conditional
Formatting. This was looking promising, however the formatting options
available when using Conditional Formatting don't appear to include
currency.

Anyone have any tips or a solution?

Many thanks, Steven.

 

[Rick Rothstein \(MVP - VB\)]

It might help if you tell us what your "certain condition" is so that we
know what it is you are trying to do.

Rick

 

[emailus]

It might help if you tell us what your "certain condition" is so that we
know what it is you are trying to do.

Rick

Thanks Rick. What I have at the moment is a form, with which a user
can select one of three currency options - AED, AUD, or USD. Depending
on which currency is selected, a 1, 2, or 3 respectively will be
placed in, say, cell A1.

So what I want to do for, say, cell A2, is format it to show the
correct currency. In other words, "If cell A1 = 1, then the currency
format should be AED. If cell A1 = 2, then the currency format should
be $. If cell A1 = 3, then currency format should be $."

Hope that clarifies.