Through this post you will be able to learn how to conditional format a list if its items are matched with items from another list. For some people its may be really helpful. Please note that these steps will work well for both Excel as well as google sheets. In the video there are clear step-by-step instructions along with explanation. However, if you are too lazy to watch, you can just follow the steps after the video.