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

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

Believe you would need to run a macro to reformat the cells. Place your
code in the change event or perhaps the calculate event.

Conditional formatting doesn't support changing this aspect of the format

Normal cell formatting doesn't support conditions based on another cell.

--
Regards,
Tom Ogilvy

"scott23" wrote in message
om...
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