Compare Excel and color matched rows

Help
1

Hi All,

I just need a small help,
I have two excels where I need to compare the rows in specified column in both excels and need to color the matched rows.
Ex:
Excel1:
image
Excel2:
image

I need to color 10,20 values in both the Excel files.

Thanks!

2

Hi @SaiKrishna147

Use set range color based on empty range

Thanks
Ashwin.S

3

I am done with read excels and comparing matched rows. Problem here is with coloring the excels rows.

4

Hi @SaiKrishna147

Check this

How To Set Color of Row Based on Value on Cell?

Thanks
Ashwin.S

5

Empty range works? Let me check.

Thanks!

6

Hi @AshwinS2,

leaving out range empty is not allowed.
can you please share a screenshot?

7

This is resolved. I gave dynamic range using counter. Thanks

8

Hi @SaiKrishna147

Based on datatable.rows.count Right
Thanks
Ashwin.S

9

Correct! and gave ‘cellvalue+ counter’ in color range activity.

10

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.