Posted to microsoft.public.excel.worksheet.functions

Yendorian

external usenet poster

Posts: 32

Conditionally formatting currency

In Excel 2003 Pro, is there any way of formatting currency in number format
conditionally - and how is it done?
For example, cell A1 can be Â« $ Â», Â« ‚¬ Â», or Â« Â£ Â».
If cell A1 is Â« $ Â», then the contents of cell B1 should be formatted with a
$ sign whereas if A1 = Â« ‚¬ Â», then the contents of cell B1 should be
formatted with the ‚¬ sign and so on.
Thanks for any help

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
Conditionally Formatting	phmckeever	Excel Worksheet Functions	1	August 25th 06 03:00 PM
Conditionally Formatting/Code Only One Word in a Formula	kdlilly	Excel Worksheet Functions	1	August 10th 06 04:35 PM
Conditionally formatting rows	junoon	Excel Worksheet Functions	4	May 29th 06 10:36 PM
Conditionally formatting highest valued cell?	brett	Excel Worksheet Functions	10	December 22nd 05 08:30 AM
Conditionally formatting other cells?	brett	Excel Worksheet Functions	3	December 20th 05 11:09 PM

All times are GMT +1. The time now is 05:00 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us