2 Database tables comparission in Excel

[prasadsbrk]

Hi,

The same code i'm using & it is comaring Sheet1 Row1 with Sheet2 Row1, Sheet1 Row 2 with Sheet2 Row2, .. so on.
But for me Data is in random rows as below

Code:

Sheet1 Row1 = Sheet2 Row1
Sheet1 Row2 = Sheet2 Row2
Sheet1 Row3 = <<No data here>>
Sheet1 Row4 = <<No data here>>
Sheet1 Row5 = Sheet2 Row3
Sheet1 Row6 = Sheet2 Row4
<<No Data here>> = Sheet2 Row5

.............
..........
like so on
But common field is there to (Column A) to know, so using this i need to compare. as below

- If <<NO DATA>> highlight the entire row in one color (e.g. Sheet1 in Yellow & Sheet2 in Green)
- If DATA Found (with ref. to Column A) and mismatches in other columns highlight in one color (e.g Red)

Can any one help me on this.

Thanks