In cell c1

=COUNTIF(B1:B100,"Yes")

In cell c2

=if(C1=60,do condition a,do nothing)


"Noah Negrin"
wrote:

When conducting a vote and tallying results in excel, the two responses are
€˜YES and €˜NO. If 100 people are going to vote, and it requires 60 €˜YES
responses for the vote to pass, how can I program excel to count the €˜YES
votes and do something when it hits 60? If I could have it highlight the
cell below the voting results Green or something, that would be perfect.