Drop down list automatic color

[Serrre]

Hi,

I have made a drop down list with ''Yes'' and ''No'', when all the cells in the T column are on ''Yes'' i would like the selected cell that says ''FALSE'' on ''General tasks to do'' which is on the left side to automatically color itself. (In this case green)

I had already found a formula but this does not seem to work.

Thanks for your time

 

[Serrre]

Your original formula would need to be wrapped in the IF function. Try

=IF(AND(put all of your And tests here),"Yes", "No")

The problem with posting pictures of code or formulas is that most people are not going to type out long versions so you'll need to interpret the message given.

Any idea why this is not working?

All 13 are on Yes so should it not switch to ''Yes'' now?

Thanks for your time

 

[Micron]

Why are you using two counting functions? Should only be the first one?

 

[Asbestos_Jen]

You've combined the formulas provided by me and Micron into one invalid argument. You can have either the countif()=counta() or countif()=13, but not both. If your range will always be 13 cells, use that formula.

=if(countif(R5:R17,"Yes")=13,"Yes","No")

 

[Serrre]

You've combined the formulas provided by me and Micron into one invalid argument. You can have either the countif()=counta() or countif()=13, but not both. If your range will always be 13 cells, use that formula.

=if(countif(R5:R17,"Yes")=13,"Yes","No")

Thanks Asbestos_Jen, really helpful. Working now!