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

S

scott23

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
 
T

Tom Ogilvy

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.
 
Top