Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

How to correct if currency is in currency table, but currency symbol is highlighted red?

Dear Vidas,

I am working with 3 currencies EUR, CAD and USD. The Initial configuration had been done according your instructions.
See attached screenshot showing my currency table.
Nevertheless I get the red highlighted table cell, when I am adding my first stock Symbol with currency = EUR.

Where could I check to solve the problem indicated by the red highlighting shown in the srcSymbol sheet in the currency column of the Symbol table?

Many thanks for your guidance.

Kind regards,
Sunny


Comments

  • Hi, There is a problem in PS worksheet in Symbol worksheet - testing for currency does not include all currencies. You can ignore this - there will be no impact.
    To fix it (Instructions for Excel 2010, but will be very similar to Excel 2013/2016):
    1. Go to srcSymbol worksheet.
    2. Select any cell in Symbol pivot table.
    3. From "Home" menu choose "Conditional Formatting", then "Manage Rules..."
    4. Select rule that has "Applies to" =$C$2:.$C$..., click "Edit Rule...".
    5. Replace existing rule with new rule:
    =AND(COUNTIF(src!$N$5:$N$7, C2)=0, LOWER(C2)<> "cash")
    6. Save rule.
    7. Done
  • that solved it.
    Many thanks for your reply at the speed of light.

    Wish you a great day
Sign In or Register to comment.