Forum Discussion
Conditional formatting in Excel
Brewster56 Most likely, the texts you copied from the web contains "white space" that isn't empty. These can be trailing spaces or other hidden characters.
For a computer "Name" is not equal to "Name " (i.e. "Name" plus three spaces) even though they may look the same in your Excel document. Locate two cell in the data you copied from the web that look the same to you. Let's say A2 and A10 seem to be duplicates. Type the following formula somewhere:
=A2=A10If the result is FALSE, they ar NOT duplicates and conditional formatting will not highlight them.
You can try functions like TRIM, CLEAN or SUBSTITUTE to clean-up the data. If this does not resolve the issue, perhaps you can upload a copy of the workbook (as long as it doesn't contain any private and confidential information).
Brewster56 Most likely, the texts you copied from the web contains "white space" that isn't empty. These can be trailing spaces or other hidden characters.
For a computer "Name" is not equal to "Name " (i.e. "Name" plus three spaces) even though they may look the same in your Excel document. Locate two cell in the data you copied from the web that look the same to you. Let's say A2 and A10 seem to be duplicates. Type the following formula somewhere:
=A2=A10If the result is FALSE, they ar NOT duplicates and conditional formatting will not highlight them.
You can try functions like TRIM, CLEAN or SUBSTITUTE to clean-up the data. If this does not resolve the issue, perhaps you can upload a copy of the workbook (as long as it doesn't contain any private and confidential information).