Google Sheet Conditional Formatting for Different Ranges

I'm an Excel user for may years and I'm good at working with excel conditional formatting. However When my clients asked me to do a google sheet conditional formatting to compare and Highlight two different list , i ran into a problem. The first thing i did was using the functions i use within Excel,
However Google Sheet doesn't support conditional formatting with 2 sheets. But Google let us get this done via Google Script, it is a good choice if you are familiar with Google Script.

I don't think many of you would like to go with google script due to your Google Script Knowledge. This tutorial is intent to provide an alternative method using google sheet functions.


I assume you have opened a google sheet.
Now Copy and Paste the Data from this below sheet and name it "Data1"