How do i change the format of a cell based on the condition of another cell in same row?

Posted to microsoft.public.excel.programming

external usenet poster

Posts: 15

How do i change the format of a cell based on the condition of another cell in same row?

For example:

ED -1 SHORT $98.13 $98.12
ZB -1 SHORT 107 28/32 107 27/32

If A1 ="ED", then id like D1 & E1 to be formatted as currency
If A1 ="ZB" then id like D1 & E1 to be formatted as fraction 1/32

etc

Thanks

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
I want to change the cell format (color) based on a calc	mtnmanus	Excel Discussion (Misc queries)	4	August 6th 08 11:14 PM
Conditional format: change row color based on cell value	Carelle	Excel Discussion (Misc queries)	2	January 3rd 08 09:26 PM
Change Currency Format of Cell based on another Cell	Simon	Excel Worksheet Functions	2	September 2nd 07 04:53 PM
I want to fill the cell color based upon the other cell condition	sri	Excel Discussion (Misc queries)	4	January 12th 06 01:47 PM
How do I change the format of a cell based on what I input?	Husker87	Excel Worksheet Functions	8	August 19th 05 10:45 PM

All times are GMT +1. The time now is 02:07 PM.

Menu

About Us