Highlight column matches

[joeyga]

Hi folks,

I'd appreciate any help on this as I am a novice and really don't want to do this manually!

I have a spreadsheet with over 100 rows and 100 columns. I want to highlight any columns which contain the exact same values. The entire column needs to be identical to the other highlighted column. So for example:

If Column A is the exact same as Column B and Column D then highlight all of the columns in orange.
If Column F and Column C contain the same values then highlight all of the columns in brown.
If Column G does not have a match then don't highlight.

An example of what I mean is attached.

Thanks for any help,
Thanks,
Joe

[mehmetcik]

Hi Joe

There are lots of ways of doing this

The simplest is conditional formatting.

We can turn any cell that is the came as column a orange
and any cell that is the same as column c brown

is that what you need?

[joeyga]

Hey,

Cheers for the reply, but I don't think that is what I need. I don't want to highlight individual cells that contain the same value in other columns. I want to highlight a column, when the entire column is exactly identical to another column. Matching columns need to be highlighted in the same colour.

Thanks,
Joe

[mehmetcik]

Ok

I now understand your requirement.

Bear with me.

[mehmetcik]

Hi

The attached file has a macro that will paint column b and any duplicate column green if there are duplicates.

Is that the sort of thing you need?

Please advise so that I can extend the macro for you tomorrow

[joeyga]

Hi,

Thanks for your help here. That's exactly the sort of thing I need. It now needs to be extended to highlight any other matching columns (e.g. D&F) in a different colour.

Thanks again,
Joe

[mehmetcik]

Hi

I have modified the Macro

You can now have six different sets of matching columns and they will be colour coded in six different colors.

Enjoy.

[kalak]

just for your amusement

Please Login or Register  to view this content.