Forum Discussion
Using COUNTIF for conditional formatting, works for some cells but not others
I am trying to compare two lists of 13-digit book ISBNs (my inventory and a publishers inventory), and want the ISBN highlighted on my list if it appears on the publisher's list. My problem is t...
thumy Find an ISBN that you think should be formatted and the cell in the publisher's list, and do an =A1=B1 style comparison formula. Excel should say TRUE if they truly are equal.
Numbers and text aren't seen as the same so that's one possibility. Excess spaces you probably covered with TRIM already. Leading 0s don't stay unless things as formatted as text, that could be happening. Really without seeing the data I can only make generic suggestions.