Lookup and change to italic italic

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi Doug,

A Conditional Formatting will help you in this matter. You will get it
from Format/Conditional Formatting.

Hope that helps,

Thanks,

Shail
 
Shail,
I would normally use in column E, =VLOOKUP(D2,$A$2:$B$10,2,FALSE) which
would change any price that has changed in column B.
How will a conditional format recognise the change ?
Am i complicating something that is very easy ?

Thanks
 

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

Need Min Value from Row and Heading Value that Corresponds to it. 1
SUMPROD and OTHER FUNCTIONS!!! VERY URGENT 1
With F1 value, look at A, if match or partial match return B 5
Using lookup function - HELP!! 8
Lookup 9
Adding intermittent rows to a spread sheet 2
Two Variable Lookup with approximate ranges 12
What function(s) to use to pick up a value based on two variables? 6

Back
Top