Here's how to create a heat map in Google Sheets. This is the easiest method, which is the conditional formatting feature.