Conditional Currency Formatting

  • Thread starter Thread starter wagonboytim
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format Changes When Using CopyFromRecordSet 0
export to XL - problem with currency format from cells 1
Can't get the popup calendar to work when I protect the workbook 6
currency format 1
conditional number format dependent on other cell 2
unable to set the numberformat of the range class 2
Unable to set a cell's format as currency 1
Conditional Formatting niggle 10

Back
Top