View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Doug Doug is offline
external usenet poster
 
Posts: 460
Default Lookup and change to italic italic

I need a lookup formula that can convert a price change to italic if it is
different to the existing price.
Example below,the price in E2 has changed and therefore needs to show as
either Italic or bold or both.
Any help appreciated.


A B C D E
1 Code Price Code Price
2 AB1237 £4.00 AB1234 £1.06
3 AB1234 £1.02 AB1235 £2.00
4 AB1235 £2.00 AB1236 £3.00
5 AB1236 £3.00 AB1237 £4.00

Doug