Excel Auto Formatting Help

  • Thread starter Thread starter CS
  • Start date Start date
C

CS

I have a workbook to record orders. I have set data validation for the
product codes so that product name, description and supplier are
entered. I would also like to set the format on the price field so
that if I choose 'X' product the price cell format is £ or if I select
'Y' product the cell format is in €.

Thanks
 
Try setting up a separate table that contains your prices, then you can do a VLOOKUP or HLOOKUP to find the price that correlates to that code.

Another method would be to do an "IF, THEN" statement. IF(C2=X,"$50", IF(C2=Y,"$80","")) or something like that.
 
LAT said:
Try setting up a separate table that contains your prices, then you can do a VLOOKUP or HLOOKUP to find the price that correlates to that code.

Another method would be to do an "IF, THEN" statement. IF(C2=X,"$50", IF(C2=Y,"$80","")) or something like that.
Click to expand...

The only problem is that the price is variable depending on how many
products are ordered the only thing that is consistent is the currency
type. Although the currency type will change with different products
e.g. product 'X' is in $ but for one customer this could be $10 for
another $20 depending on how many they order, credit agreements etc.
Product 'Y' will be in £ but again the value could change. So I need
to format the cell depending on the product code.

Thanks for any help
 
Back
Top