Hello All

Please excuse me for an unclear subject. I will try to decribe my problem as
clear as possible.

I have a spreadsheet which helps me measure productivity of my staff. I have
three departments (BULK, FLAT PICK and HANG PICK). Each spreadsheet contains
following::
NAME | TOTAL PICK | TOTAL TIME | AVG UPH | TARGET |
John Doe 10,000 100 100 120

I have a list of over 200 employees with these figures. I am trying to find
a way to force excel to identify people who are not reaching the target
(which changes every week depending on the type of product comming through
the door) group them all in one table on a separate tab which I can hand out
to Team Leaders.
Please remember that I would like that info to be shown on a separate tab.

I know a bit about excel but this is simply out of my league.

Hi,

Suppose you enter the target value in cell H1 with your data in A1:D100 with
titles on row 1:

In 2003:
1. Select the cells you want to format
2. Choose Format, Conditional Formatting
3. Choose Formula is from the first drop down
4. In the second box enter the formula:
=$D2<$H$1
5. Click the Format button
6. Choose a color on the Patterns tab (or any available option)
7. Click OK twice.

In 2007:
1. Highlight all the cells on the rows you want formatted, possibly A2:D100
in your case
2. Choose Home, Conditional Formatting, New Rule
3. Choose Use a formula to determine which cell to format
4. In the Format values where this formula is true enter the following
formula:
=$D2<$H$1
5. Click the Format button and choose a format.
6. Click OK twice
--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Barry" wrote:

Hello All

Please excuse me for an unclear subject. I will try to decribe my problem as
clear as possible.

I have a spreadsheet which helps me measure productivity of my staff. I have
three departments (BULK, FLAT PICK and HANG PICK). Each spreadsheet contains
following::
NAME | TOTAL PICK | TOTAL TIME | AVG UPH | TARGET |
John Doe 10,000 100 100 120

I have a list of over 200 employees with these figures. I am trying to find
a way to force excel to identify people who are not reaching the target
(which changes every week depending on the type of product comming through
the door) group them all in one table on a separate tab which I can hand out
to Team Leaders.
Please remember that I would like that info to be shown on a separate tab.

I know a bit about excel but this is simply out of my league.

Hi,

I think you are looking for something like this - Question 7 on
http://ashishmathur.com/knowledgebaseII.aspx

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Barry" wrote in message
...
Hello All

Please excuse me for an unclear subject. I will try to decribe my problem
as
clear as possible.

I have a spreadsheet which helps me measure productivity of my staff. I
have
three departments (BULK, FLAT PICK and HANG PICK). Each spreadsheet
contains
following::
NAME | TOTAL PICK | TOTAL TIME | AVG UPH | TARGET |
John Doe 10,000 100 100
120

I have a list of over 200 employees with these figures. I am trying to
find
a way to force excel to identify people who are not reaching the target
(which changes every week depending on the type of product comming through
the door) group them all in one table on a separate tab which I can hand
out
to Team Leaders.
Please remember that I would like that info to be shown on a separate tab.

I know a bit about excel but this is simply out of my league.