+ Reply to Thread
Results 1 to 4 of 4

USD or EUR conditional formatting depending the value of another cell

  1. #1
    Registered User
    Join Date
    02-17-2015
    Location
    Turkey
    MS-Off Ver
    2010
    Posts
    3

    USD or EUR conditional formatting depending the value of another cell

    Lets say there are values in cells B1 - B20.

    I want the formatting to be in currency format, and if cell A1 equals 1, then formatting of above cells should be euro currency format, and if cell A1 equals 2, formatting should be usd currency format.

    What I did and which did not work is: I used conditional formatting and use a formula. I created 2 conditional formatting rule for the same cells depending on the value of cell A1 but it doesnt work. It does it once and it keeps the same last formatting for the rest and it doesnt matter what the value of cell A1 is.

    I looked thorugh the previous posts regarding conditional formatting but couldnt find anything similar. Any suggestions?

    ****I forgot a little detail here. I am using a dropdown box to identify the value of cell A1. Attached is a simple sample.SAMPLE.xlsx
    Last edited by medeniz; 02-25-2015 at 12:00 PM.

  2. #2
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: USD or EUR conditional formatting depending the value of another cell

    Worked for me, see attached. What I did was highlight column B and did Conditional Formatting, New Formatting Rule, Use Formula to determine which cells to format, then in the "Format values......" field I put
    Please Login or Register  to view this content.
    , then another conditional format the same way with 1 instead of 2, then click format button, choose currency, then change to the currency you want for 1 and 2.
    Format for Euro USD.xlsx
    1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
    You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.

    Tom

  3. #3
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,038

    Re: USD or EUR conditional formatting depending the value of another cell

    You need two formulas

    Select the cell

    Conditional Formatting
    New Rule
    Use a formula to determine...

    =(A1=1)
    Format as Euro
    =(A1=2)
    Format as Dollar

    Use Format painter (paintbrush icon) to copy to any other cells

    This works, so if its not working for you, then you need to ensure A1 is changing from 1 to 2 dependant on your dropdown box.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  4. #4
    Registered User
    Join Date
    02-17-2015
    Location
    Turkey
    MS-Off Ver
    2010
    Posts
    3

    Re: USD or EUR conditional formatting depending the value of another cell

    Normally these work if you input the reference number yourself, but when I use a dropdown box it is not working?????

    And the output of the dropdown box is changing for sure. I checked it several times.
    Last edited by medeniz; 02-26-2015 at 03:49 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Conditional formatting depending on cell
    By Jeffro2p in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-22-2014, 10:37 PM
  2. Conditional formatting depending on cell
    By Jeffro2p in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-07-2014, 03:07 PM
  3. [SOLVED] Conditional Formatting Depending on Value of Other Cell
    By Ednarb in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-18-2014, 01:14 PM
  4. [SOLVED] Excel 2007 : Conditional formatting depending on cell value
    By djsouljah in forum Excel General
    Replies: 2
    Last Post: 05-29-2012, 03:04 AM
  5. Conditional formatting depending on another cell
    By 123wc in forum Excel General
    Replies: 4
    Last Post: 01-26-2012, 01:16 PM

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