Heatmap in Numbers (colouring cells by their numeric value)

Solution 1:

Yes, you can do it in Numbers but it's not a simple command as far as I know. Your spreadsheet should have numbers in each cell and that represents the size and shape of your color map. Select your matrix and under the Format menu of Numbers, click on Conditional Highlighting. That gives you a pane that looks like so:

In the top right you see a button for Add a Rule. Click this button and set up your rules for your heat map. See next image.

I used only 4 colors but I just set up this quick example. You can have as many as you want, you just have to set the rules correctly. It the Add a rule your get a pane like shown below to select your rules.

I used the rule "Between two numbers" because it was easiest for this example...