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