Cell color fill according to currency

[petmak]

Hi.
can you please help,
I am working with accounting file that contain 7 different currency, how can I format the cell when I choose EUR for example it change color for this cell to 40% green, if I enter CAD number it change color for this cell to 40% Red and so on.
I am using general accounting formation but because it is too much I need to differentiate between currency using the color
Thank you.

[loginjmor]

Hi -

Can you post a sample spreadsheet with any sensitive data removed and a couple of examples of what you are trying to do?

[petmak]

Hi.
Please find details below
Jan Price Feb Price Mar Price Apr Price May Price Jun Price Jul Price Aug Price Sep Price Oct Price Nov Price Dec Price
Item 1 USD 10.00 EGP 10.00 CHF 10.00 EGP 10.00 EUR 10.00 EGP 10.00 EUR 10.00 SEK 10.00 CAD 10.00 EUR 10.00 ZAR 10.00 CAD 10.00
Item 2 EUR 200.00 USD 200.00 CAD 200.00 CHF 200.00 EGP 200.00 USD 200.00 USD 200.00 CAD 200.00 USD 200.00 SEK 200.00 USD 200.00 CAD 200.00
Item 3 CAD 50.00 CAD 50.00 USD 50.00 EGP 50.00 EUR 50.00 SEK 50.00 EUR 50.00 ZAR 50.00 EGP 50.00 CAD 50.00 CAD 50.00 USD 50.00
Item 4 USD 300.00 EUR 300.00 EGP 300.00 USD 300.00 SEK 300.00 EUR 300.00 CAD 300.00 USD 300.00 EUR 300.00 EUR 300.00 EGP 300.00 EUR 300.00
Item 5 EUR 50.00 CAD 50.00 EUR 50.00 CAD 50.00 USD 50.00 CAD 50.00 SEK 50.00 ZAR 50.00 SEK 50.00 EGP 50.00 USD 50.00 50.00
Item 6 USD 250.00 EUR 250.00 EGP 250.00 ZAR 250.00 EGP 250.00 USD 250.00 EUR 250.00 EUR 250.00 EUR 250.00 EUR 250.00 ZAR 250.00 USD 250.00
Item 7 CAD 190.00 CHF 190.00 USD 190.00 EUR 190.00 EUR 190.00 ZAR 190.00 USD 190.00 CHF 190.00 ZAR 190.00 CHF 190.00 USD 190.00 CHF 190.00
Item 8 EUR 389.00 SEK 389.00 EGP 389.00 EGP 389.00 SEK 389.00 CHF 389.00 EGP 389.00 USD 389.00 CAD 389.00 ZAR 389.00 SEK 389.00 EUR 389.00
Item 9 CHF 1,000.00 USD 1,000.00 SEK 1,000.00 EUR 1,000.00 USD 1,000.00 CHF 1,000.00 CAD 1,000.00 EGP 1,000.00 USD 1,000.00 EUR 1,000.00 CHF 1,000.00 USD 1,000.00
Item 10 ZAR 0.90 ZAR 0.90 EUR 0.90 EGP 0.90 EGP 0.90 ZAR 0.90 SEK 0.90 ZAR 0.90 EGP 0.90 ZAR 0.90 EUR 0.90 SEK 0.90

thank you for your help in advance.