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.