Conditional Currency Formatting

W

wagonboytim

Hi,

I would like the currency format of my cells to change depending on th
value of a combox or cell. I know this can't be done using conditiona
formatting.

I have tried using the .NumberFormat code in VBA but I get th
following error

Run-time Error '1004' Unable to set the NumberFormat property of th
Range Class.

I am using Excel 97.

Ideally, I'd like to solve this without using code!

Any ideas
 
J

Jason Morin

Without knowing more, I can't provide a detailed
solution. But this example may help. If A1 is greater
than 100, format as $. If not, format as £.

[>100]$#,##0.00;£#,##0.00


HTH
Jason
Atlanta, GA
 
Top