Conditional formatting

[le clef]

Good evening to all !

I use Excel 2003.

I have a simple production log used to match man hours against production
hours.

What I am trying to achieve is :

If the the total production hours are in excess of the available man hours -
two conditions -

1. If the production hours are more than (say) 3 hours the cell showing the
available hours turns a selected colour.
2. If the production hours are more than (say) 5 hours the cell showing the
available hours turns another colour.

The production team very often make time and so a 3 hour over booking is
achievable but a warning needs to show. But if the production time is 5 hours
above the available hours it is not possible to achieve and it needs to show
in a more forceful way !

Just to be clear - I am only trying to highlight 1 cell - the 1 that shows
the difference between the available man hours and the total production hours.

I have tried to use conditional formatting - which I think should solve the
problem - but fall over on the way to do it !

I hope the problem is clear - any help on this is very much appreciated..

 

[Luke M]

Let's assume your total production hours is in cell A2, available hours is in
B2
Select the cell you want format on.
conditional format - 1st formula is:
=AND(A2-B2>3,A2-B2<=5)
(pick color)

2nd formula is:
=A2-B2>5
(pick color)
ok out.

 

[le clef]

Thank you very much for you time and trouble - your answer has worked just as
I had wanted - very much appreciated. Kindest regards.