Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting
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.. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting
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-B23,A2-B2<=5) (pick color) 2nd formula is: =A2-B25 (pick color) ok out. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "le clef" wrote: 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.. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting
Thank you very much for you time and trouble - your answer has worked just as
I had wanted - very much appreciated. Kindest regards. "Luke M" wrote: 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-B23,A2-B2<=5) (pick color) 2nd formula is: =A2-B25 (pick color) ok out. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "le clef" wrote: 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.. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I convert conditional formatting into explicit formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |