Filtering rows of data based on conditional formatting rules

[JDM-LTCS]

I have a survey broken into 6 sections that each employee took. Based on those results, I need to email the individuals with a sub-par score for a support training.

The data looks something like this:

Name Job Type 1. 2. 3. 4. 5. 6.
Teacher 1 Teacher 96% 89% 98% 92% 91% 92%
Employee 1 District Personnel 100% 98% 100% 100% 100% 100%
Teacher 2 Teacher 100% 100% 100% 92% 100% 100%
Employee 2 District Personnel 100% 98% 100% 83% 100% 96%
Teacher 3 Teacher 100% 98% 89% 83% 100% 96%
Employee 3 Other 96% 73% 100% 83% 82% 96%
Employee 4 Other 42% 80% 100% 92% 73% 79%

I used conditional formating to highlight the cells of scores <80%. Now I need to find a way to easily select the employees/teachers with a score that's been flagged/highlighted.

Any suggestions? Thanks!!

 

[Andrew Poulsom]

Put your conditional formatting formula in a spare column and autofilter on that column.

 

[JDM-LTCS]

Hrmm... I must be using CondFormatting incorrectly. It simply highlights the individual score that is <80%. I don't see how to insert a rule into an adjacent column based on the data in other columns.

 

[Andrew Poulsom]

If the data you posted is in the range A1:H8, type a heading in I1, eg Show. In I2 enter:

=COUNTIF(C2:H2,"<80%")>0

and copy down.

 

[JDM-LTCS]

That worked! I didn't think of the CounIf func.


Thanks again!