Hi Gord,

No, I am using a version prior to 2007, and I divide my columns into
different worksheets to get around the 256 limitation.

What I am looking at are columns of amino acids within a multiple
alignment, so I am really interested in how these change. Thus,
columns that are completely identical are discarded and only those with
variation are highlighted. The problem is that some of the columns
have five or more differences, and I cannot find an easy way to
highlight all of the changes as different colors. Do you have any
ideas?

Thanks,

Eric

Gord Dibben wrote:
Eric

You have twice mentioned hundreds of columns.

Versions of Excel prior to 2007 have only a maximum of 256 columns.

Are you using 2007 version?

Just curious.................maybe you have rows and columns mixed up?


Gord Dibben MS Excel MVP

On 6 Nov 2006 13:51:50 -0800, "Eric" wrote:

Hi Dave,

Yes, i have tried the conditioonal formatting with mixed results. It
does save some time, but is still tedious over several hundered
columns.

How would I write a macro to do it? Can you suggest a tutorial?

Thank you,

Eric
Dave F wrote:
If you have 3 or fewer conditions you want to apply you can use conditional
formatting, via Formatting--Conditional Formatting.

More than three--then you have to write a macro...

Dave
--
Brevity is the soul of wit.


"Eric" wrote:

Hi Everyone,

I have a task that I have been doing by hand that is tedious and
inaccurate, and I am hoping a clever reader will be able to help me. I
have several columns of data in an Excel table that I would like to
quickly analyze and determine were the differences are. For example, I
might have 20 rows, and in column 1 I might have 19 'A' and 1 'V'; in
the next column I might have 6 'D', 8 'E', 5 'N', and 1 'Q', etc. What
I do by hand is highlight each change with a different color so that I
can track how and where they change.

Is there a macro that could do this? It is very tedious and time
consuming (not to mention in accurate) for me to do this by hand,
particularly when dealing with several hunderd columns and a 100 or so
rows.

Thank you in advance.

PS I have never written a macro, I just know that they are amazing!

Warm regards,

Eric