Conditional formatting, looking for changes in date

J

jillykate

I am having a problem coming up with a conditional format to tell me
when 2 sets of data have changed.

For example, I have two columns, one with a ID number and the other
with a Letter. I want to compare it to another set of columns with the
same data and show me where the letter has changed for a particular ID
number. I would like have the changes highlighted.
 
P

Per Erik Midtrød

If you have the following layout:
ID in column A, Letter in column B and your other set in D and E the
following condtiontal format should work:
=VLOOKUP(A2;D:E;2;FALSE)<>B2

Per Erik
 
J

JethroUK©

you can use a formula to compare columns

C1 =A1=B1

will return 'True' if A1 and B1 are the same, or 'False' if A1 and B1 are
different

just copy the formula down as far as ness
 
Top