Conditional Formatting not working completely

[WINDSEAKER]

Conditional Formatting not working completely
I have tried a lot of things to correct this issue, not sure what else to try.
I have purged to a new worksheet
I have purged to a whole new excel page.
I have purged data columns to “notepad”
I have cleared “formatting” in cells
I have cleared “rules” from cells
I have used new rule with “countif”
I have used new rule with “match”
All with same results which is the conditional formatting will work sometimes!

What’s going on , here is my worksheet to give it a try…….

[Jonmo1]

They all look to be working correctly to me.

What are they NOT doing that is different than what you expected ?

[WINDSEAKER]

You will see that the formatting stops like at sheet1(2) line 35. H35 is 25 but I35 is 10, I 35 is not highlighting!!

[Jonmo1]

For that sheet, you chose the built in conditional format for Unique Values, and applied it to range $H:$I
What that does is highlight values that are unique in the entire referenced range..
i.e., highlights any value that only appears one time in the entire range.

I35 = 10, but so does I36. So it is NOT a unique value, therefor it is not highlighted.


If what you want is to highlight where values in I are Not the same as the value in H, then you would use
=$I2<>$H2, and applies to range $I$2:$I$1714



I think it's probably similar issues for the other 2 sheets. The Conditional formats you set up do not do what you think they do.

[Jonmo1]

For Sheet1 (3) you have
=COUNTIF($H$2:$H$1714,I2)=0, applied to $I$2:$I$1714
That will highlight values in Column I that do not exist in column H.
And it appears to be working correctly.

For Sheet1 (4) you have
=MATCH(I2,$H$2:$H$1714,0), also applied to $I$2:$I$1714
That will highlight values in column I that DO exist in column H.
And it appears to be working correctly.

[WINDSEAKER]

You are correct!

it is NOT a unique value!

I was with the goal to find the difference of the two columns and high light them.

Thank you a great deal...

Please enjoy the holidays, while we still can.

[Jonmo1]

You're welcome.

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.