Conditional formatting

  • Thread starter Thread starter le clef
  • Start date Start date
L

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..
 
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.
 
Thank you very much for you time and trouble - your answer has worked just as
I had wanted - very much appreciated. Kindest regards.
 
Back
Top