Conditional Formatting for bottom 10 values

[jontyoc]

Hi All,

I have a spreadsheet of hours worked by an agent compared to their expected scheduled hours, and then expressed as a percentage.

What I would like is to highlight the bottom 10 agents - but ignore those with a 0 value. If they dont work that week I dont want them highlighted.

Using Excel 2007 and the Bottom 10 rule at the moment, but it highlight all those 0 values.

I had tried to create another rule above this
If cell value = 0 then stop rules.

I hope this makes sense.

Thanks for your help.

 

[jontyoc]

Little after thought -

Here is the original cell formula "=SUMIF('AGENT '!$B:$B,$A5,'AGENT '!W:W)"
Could I change this so if there is a 0 value it posts nothing in the cell?
Then if I run the conditional formatting it will ignore these cells.

Thanks.