First of all, you should select the cells to which you have already applied CF to in March, then click on Conditional Formatting | Clear Rules | Clear rules from selected cells.

Then select cell W8 and click on Conditional Formatting | New rule | Use a formula... , then put this formula in the dialogue box:

=W8>=24

Click on the Format button | Fill tab and choose Red, then OK your way out.

Repeat, but use this formula:

=AND(W8>=16,W8<24)

and choose amber as the fill colour. Repeat once more, using this formula:

=AND(W8<16,W8<>"")

and choose green for the colour.

After exiting the CF dialogue, you can select cell W8 and double-click the Format Painter icon - this enables you to apply those conditions to other cells until you press the < Esc > key, and as all the references to W8 are relative, they will automatically change for other cells. So, you can click on the cells X8 (and also on T8, U8, V8 in turn). Press the < Esc > key, then select the cells T8:X8, then double-click on the Format Painter icon again, the click on T10, T12, T14 and T16 to apply those CF conditions to the whole month, and press < Esc > again.

You can then repeat this for all the other months.

Hope this helps.

Pete