cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

How to conditional format one cell's colour, based on frequency of colour in other cells?

MJ_18
Copper Contributor

‎Oct 04 2019 08:06 AM - edited ‎Oct 04 2019 08:07 AM

‎Oct 04 2019 08:06 AM - edited ‎Oct 04 2019 08:07 AM

How to conditional format one cell's colour, based on frequency of colour in other cells?

I would like to conditional format one cell's colour, based on frequency of colour in other cells.
For example

 

H128 to change to red, when more than 5 cells in the range H120 to H127 are also red.

Labels:
328 Views
0 Likes
0 Replies
Reply
0 Replies