Comparing Data

Z

zephyr

I have 10 rows in excel all containing data in 15 columns. I want to be able
to select any three rows and highlight any differences by changing the
background color of the cell. Any ideas.

Many thanks
 
B

Bob Phillips

Look at conditional formatting.

You would select the three rows by 15 columns and use a formula similar to

=OR(A$10<>A$14,A$14<>A$23)

depending upon the three rows

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
Top