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


<(E-Mail Removed)> wrote in message
news:27a99a13-08a6-4f8f-8e8c-(E-Mail Removed)...
>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\)"
<rick.newsNO.S...@NO.SPAMverizon.net> 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.