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

  • Thread starter Thread starter scott23
  • Start date Start date
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
 
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.
 
Back
Top