Conditional Formatting to show progress against a target

Hi Guys,

I have a spreadsheet that has the below information;

A1 - Target Revenue For Month

B2 - Daily Revenue
C2 - MTD Revenue

What I want is conditional formatting (red/green) to show whether the MTD Revenue is on target to achieve the Target Revenue For Month. For example, the Target Revenue For Month will be £1000, and this divided by 30 days = £33.33 per day. The conditional formatting will show if still on target (achieving more that £33.33 per day on average).

Hope this is clear?

Thanks in advance

Use a formula for the CF on cell C2, along the lines of:

=C2 > $A$1/30

for green and change the > to < for the red condition.

Hope this helps.

Pete