Conditional Formatting

[Hazeyt]

Hoping someone can help please.

I need to highlight any percentages that are greater than 9% in red but only for a department with 20 or more people.

Is there a formula for this?

G16 to S163 are the percentages but need to look up B16 to B163 to see if 20 or more.

Thanks

 

[6StringJazzer]

Is this one department per row, and column B has the number of people?


Rule "Applies To" range: $G$16:$S$163
Rule using a formula:

=AND(G16>9%,$B16>=20)

 

[Special-K99]

What's in B16:B163 ? You haven't said.
Are these names of people? Number of people? Names of departments? Something else?

I'll assume department names and that every cell in B16:B163 has been filled in with a department name.
Select G16:S163

=AND(G16>=0.09,COUNTIF($B$16:$B$163,B16)>20)

 

[Hazeyt]

Is this one department per row, and column B has the number of people?


Rule "Applies To" range: $G$16:$S$163
Rule using a formula:

=AND(G16>9%,$B16>=20)

Thank you so much

 

[Hazeyt]

What's in B16:B163 ? You haven't said.
Are these names of people? Number of people? Names of departments? Something else?

I'll assume department names and that every cell in B16:B163 has been filled in with a department name.
Select G16:S163

=AND(G16>=0.09,COUNTIF($B$16:$B$163,B16)>20)

Thank you