Heatmap

Hi,

I would like to create a heatmap using the attached data.

I have included a key, would be greatfull for any help.

Thanks

Select the cells C4:H13, then click on Conditional Formatting, followed by New Rule, then click Use a formula ...

In the formula box enter:

=C4<0

then click the Format button, click on the Fill tab and then choose red and OK your way out.

Do the same for the other conditions, using these formulae:

=AND(C4>=0,C4<=19) and choose amber,

=C4>19, and choose green

As you had seleceted the cells in advance, Excel will automatically adjust the formulae to suit the other cells.

Hope this helps.

Pete