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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to send email 5 days before a date mentioned in Cell 1
simple code but it doesn't look like usual vba code 2
Using values of cells in a comment 1
how do i auto filter with value in a cell 1
Conditional formatting based on numbers in columns 5
Macro - text box - conditions 4
Using cell row # in a VB macro 2
Handle a value from a Range instead of value of a Cell 8

Back
Top