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.


--
jillykate
------------------------------------------------------------------------
jillykate's Profile: http://www.excelforum.com/member.php...o&userid=33207
View this thread: http://www.excelforum.com/showthread...hreadid=530240

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




"jillykate" wrote
in message ...

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.


--
jillykate
------------------------------------------------------------------------
jillykate's Profile:
http://www.excelforum.com/member.php...o&userid=33207
View this thread: http://www.excelforum.com/showthread...hreadid=530240

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


On Wed, 5 Apr 2006 15:38:32 -0500, jillykate
wrote:


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.