Excel Macro

[phmckeever]

Two Oracle databases are being run parallel. The data in these databases
need to be verified as being the same.

sqlplus code has been developed to generates a text file of differences
between the data in the databases.

I am using an excel macro to format the data produced by the sqlplus code.
The rows that selected have identical numbers in the first column of the
report. The last piece that I am trying to accomplish is as follows:

1. Find the two duplicate numbers in the first column of the report,
2. Select the two duplicate number rows,
3. Find the cells in the rows that are different, and , finally,
4. Highlight the different cell values.

Can up help me with the coding for this?

phmckeever

[Excelenator]

If you can sort the file in Excel by the first column of numbers you can then use conditional formatting to highlight the differences as follows:

1. Highlight the full range of data
2. Select Format\Conditional Formatting... from the menu
3. Select "Formula Is" in the first drop down box
4. Enter the formula =IF($A1=$A2,A1<>A2,FALSE) in the text box to the right
5. Select your format preference
6. Click the Add button
7. For the second condition Select "Formula Is" in the first drop down box
8. Enter the formula =IF($A65536=$A1,A65536<>A1,FALSE) in the text box to the right
9. Select your format preference (same one as above probably)
10. Click OK

[phmckeever]

Excelenator,

There are highlights in the spreadsheet; but, not the cells I need
highlighted. I need to find the rows with the same row number; and, then,
highlight the cells that caused the rows to be selected. In other words, I
want to highlight the two cells in the duplicate rows that are different.

Can you rewrite the IF..statement?

phmckeever


"Excelenator" wrote:

>
> If you can sort the file in Excel by the first column of numbers you can
> then use conditional formatting to highlight the differences as
> follows:
>
> - Highlight the full range of data
> - Select Format\Conditional Formatting... from the menu
> - Select "Formula Is" in the first drop down box
> - Enter the formula =IF($A1=$A2,A1<>A2,FALSE) in the text box to the
> right
> - Select your format preference
> - Click the Add button
> - For the second condition Select "Formula Is" in the first drop down
> box
> - Enter the formula =IF($A65536=$A1,A65536<>A1,FALSE) in the text box
> to the right
> - Select your format preference (same one as above probably)
> - Click OK
>
>
> --
> Excelenator
>
>
> ------------------------------------------------------------------------
> Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768
> View this thread: http://www.excelforum.com/showthread...hreadid=573088
>
>