Highlight all rows where the data is equal through multiple columns within a Table?

[Klash Ville]

For example in an already created table with table headers,

on row number 1, I have: Car | Nissan | Japan (same)
on row number 2, I have: Car | Ford | United States
on row number 3, I have: Car | Nissan | Japan (same)
on row number 4, I have: Car | Fiat | Italy

How do I create the code in excel vba to highlight the rows of that table, where the data is exacly the same in all respective table headers?

 

[Klash Ville]

Re: How to highlight all rows where the data is equal through multiple columns within a Table?

anyone please?

 

[Stiuart_W]

Re: How to highlight all rows where the data is equal through multiple columns within a Table?

- Find your last column used unless you already know it
- Custom sort by column A to last column

- Create variable with data from cells in row 1 of data - IE Concatenate cells(2,1) + cells (2,2)+.....(cells2, last_column) call it, say, ConcatenatedData
- Loop from second row of data with data
- concatenate data as above and compare. If equal then cells(n,last_clumn_1)="Above is the same"
- Set temp variable
- Loop