Posted to microsoft.public.excel.worksheet.functions

DJ76

external usenet poster

Posts: 3

Conditional formating question

I have a column that displays currency type with a 3 digit code (ie. EUR).
Based on this code, i want to automatically update the currency type in
another column. EX

COLUMN A COLUMN B
EUR 10,345.78

Does anyone know the conditinal formula that would make this possible?
Based on COLUMN A code, Column B would format the number in the right
currency?

Been struggling with this for days!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional Formating Question	[email protected]	Excel Discussion (Misc queries)	6	December 7th 08 12:14 AM
Conditional Formating question	[email protected]	Excel Worksheet Functions	4	November 9th 08 11:58 PM
CONDITIONAL FORMATING QUESTION	Megan	Excel Discussion (Misc queries)	3	November 15th 07 02:52 PM
Conditional Formating Question	carl	Excel Worksheet Functions	4	March 10th 07 11:30 AM
Conditional Formating Question	terri	Excel Discussion (Misc queries)	3	November 27th 05 02:01 AM

All times are GMT +1. The time now is 04:32 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us