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.