Need to highlight rows with the same exact data in ActiveSheet

[Klash Ville]

Title says it all, I need help in making a macro that simply fetches all rows starting at 1 to 20 for example, and then highlight all rows that have the same exact information in its many cells.

 

[Momentman]

You can't be possibly searching through 16384 columns, where exactly does the data end?

Cos you should be able to use CONDITIONAL FORMATTING for this (with a COUNTIF formula)

 

[Klash Ville]

You can't be possibly searching through 16384 columns, where exactly does the data end?

Cos you should be able to use CONDITIONAL FORMATTING for this (with a COUNTIF formula)

For example, I have data within the rows 1 to 20, and I need an excel VBA macro code to highlight any exactly repeated rows, where the information in each row cells is exacly the same.

for example, if I have:

JAPAN - NISSAN - ALMERA
USA - FORD - MUSTANG
JAPAN - NISSAN - ALMERA
JAPAN - NISSAN - PRIMERA

I need the that the rows with Japan / Nissan / Almera to be highlighted. Just that.

 

[Momentman]

What have you have above is a 3 columns scenario, right?

 

[RoryA]

This appears to be a duplicate of your earlier thread here: https://www.mrexcel.com/forum/excel...ultiple-columns-within-table-post4930649.html

Please do not post duplicate threads. This one is now closed.