Howdy, Stranger!
It looks like you're new here. If you want to get involved, click one of these buttons!
Quick Links
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
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
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
Many thanks for your reply at the speed of light.
Wish you a great day