I have done something like this in two different ways

1 - Create a third chart and use this formula
=if(A1=K1,"Same","Different")

Use the upper left cell of each chart in place of A1 and K1

You could also use Conditional Formatting on one or both chart

for example in cell A1 use the Conditional Format

Condition 1
Cell Value - is equal to - =K1
(pick some format like Green text or shading)

Condition 2
Cell Value - is not equal to - =K1
(pick some format like Red text or shading)

If you make sure that there are no absolute references ($) in the formula
you can use the format painter to copy this to the entire table.


"Tom" wrote:

I have two data charts on the same worksheet with each chart containing 14
columns and 79 rows. Is there a way to compare the two cell by cell and then
output a "same" or "different" if and cell in the a row is different between
the two data charts? Does this have to be done cell by cell or can it be done
by ranges?