Thread: How do i change the format of a cell based on the condition of another cell in same row?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
scott23 scott23 is offline
external usenet poster
  
Posts: 15
Default 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 QuoteReply With Quote