1
http://www.shopping.shopping4all.uk/household/google-sheets-conditional-formatting-based-on-another-cell/



Conditionally format your data based on data from another range cells. Learn how to do this using several examples based on real world data.

source