Tom,

1)

Use a formula like

=IF(A2=M2,"Same","Different")

were A2 is the upper left cell of table 1, and M2 is the upper left cell of table two.

Then copy that over 14 columns and down 79 rows.

2)

Use conditional formatting.

To highlight the cells that are different, select the first table, then use Format / Conditional
Formatting... "Cell Value is" "Not equal to" and then select the upper left cell of the second
table, and press F4 until the $s disappear, like =M2. Then set the fill to red or some other
highlighting color.

HTH,
Bernie
MS Excel MVP


"Tom" wrote in message
...
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?