Hello all. My question is in regards to a column of drop downs of yes or no.
Currently I am able to do for no perfectly. But for “yes” they only success i have had so far is if one dropdown is yes, then the cell i need turns green.
(Separate cell turns green or red)
My end goal is to have a dropdown list that doesnt turn completely green unless all dropdown yes have been completed.
so far i have tried using =countif(range, CONTAINS(“yes” or “all dropdowns yes”))
IdK if its a formula or wording issue.
thanks in advance
Help Article Resources
Check out the Formula Handbook template!