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.

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


wrote in message
...
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.

On Jun 5, 1:25*am, "Rick Rothstein \(MVP - VB\)"
wrote:
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.