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