This is a question regarding conditional formatting (I think). I am trying to compare two different sets of data in columns with different lengths. I would like to only highlight the cells in column b if they differ from col m (pretty much comparing the data to a master list). In the attached example there is a conditional format I found from this website, but it highlights the same and not different values.
Please see attached example for more details. Thanks!
If you just want to reverse the highlight so it picks out the cells that are NOT in the list in column M, just change the ">" sign in the CF formula to an "=". I don't see a need for the SUM, either, so:
=AND(LEN(TRIM($B5))>0,COUNTIF($M$5:$M$10,"*"&$B5&"*")=0)
I would also advise you to double check the range that the CF rule applies to - in your sample, it applies to a broken range rather than just B5:B21
Last edited by CAntosh; 05-11-2017 at 04:37 PM.
If your problem has been solved, please use "Thread Tools" to mark the thread as "Solved".
If you're grateful for this site's existence and would like to contribute to the community, please consider posting something hilarious in our joke thread:
https://www.excelforum.com/the-water...ke-thread.html
Thanks for the help, this does exactly what I wanted! I never use conditional formatting so I am not familiar with it. ps thanks for the heads up regarding the range issue, all the best.
Glad I could help! CF is its own little world; it isn't quite as intuitive as the regular formula process, so it give it time and practice, it takes some getting used to.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks