Compare Cells across two sheets

[Topcat04]

Hi There

Hope you can help with my compare query.

Is there an easy way to use conditional formatting to highlight in red numbers that have changed in the appropriate cells.

I have two worksheets of data (Descriptions, Dates, qty's to name a few columns) and I would like to easily compare the qtys and highlight the cells where the qtys have changed from one input person to another.

Eg, Input person 1 on Monday typed 1000 into the cell
Input person 2, yesterday changed that to 1008

Thank you for your help,
TC

 

[SkipVought]

Hi,

To begin with, how do you propose to indicate that a cell value has changed?

When person 1 entered the "first" value, that TOO was a change, was it not?

Without VBA code, all you have is what is on your sheet at any on time.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[Topcat04]

Hi Skip

Yep thats all i want to be able to do is highlight a cell that has changed from one day to another. Its not important to what the value is or was...just that it has been ammended,

So what is current on the sheet between the two sheets is what I would like to compare..

Can that be done more easily?

Thanks,

 

[SkipVought]

So are you saying, for instance, that

if Sheet1!A1 does not equal Sheet2!A1

then mark as a change?

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[Topcat04]

Yes - just looking for the correct terminology in conditional formatting.

Thanks for the help

 

[xlbo]

Not sure you can use references to other sheets in conditional formatting....

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question