+ Reply to Thread
Results 1 to 2 of 2

Automatically setting currency

  1. #1
    Registered User
    Join Date
    11-16-2006
    Location
    UK
    Posts
    5

    Automatically setting currency

    I am setting up a template spreadsheet for tracking budgets. This will be used for budgets in both GB sterling and US dollars.

    Rather than have to select the relevant cells and reassign the currency symbol each time I set up a new spreadsheet, is there a way in which I can use Conditional Formatting (or some other method) to automatically format the cells based on a reference cell at the top of the sheet in which I can just enter £ or $?

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,526
    Maybe a simple macro
    when the macro is run it checks A1 if it reads 1 then Column C is UK currency, if it reads 2 then $ currecny



    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1