Comparing Data
 

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

Comparing Data
 

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)

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