FORMULA OR CONDITIONAL FORMATTING BASED ON ANOTHER CELL currency

[vba_newbie83]

Hi

Im trying to work out a formula, where column column B formatting of the currency is based on column A. Is there a simple way to get this done?

I have 1000 records and i need each cell formatting in the right currency based on column A

Thank you

[63falcondude]

I would create a lookup table that shows the formatting for each currency (I put this in F2:G7), then refer to that with a formula like this in C2:

=TEXT(B2,VLOOKUP(A2,F$2:G$7,2,0))
Drag the formula down.

You can see what formatting is being used if you select a formatted cell then go to Format Cells > Custom > Then look under Type.

See attachment.

[vba_newbie83]

Thank you this is amazing!!!!

[63falcondude]

You're welcome. Happy to help.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.