Formula giving blank as a positive

[Serrre]

Hello,

I made a drop down list at R5 : R17 with Yes & No

I wanted G11 to automatically color Green when everything is on Yes and color red when everything is on No.

But now when everything in the R column is blank and not filled in it still gives a positive green color. How do i make it so it colors red when its blank aswell?

Thanks for your time.

 

[AlphaFrog]

=COUNTIF(R5:R17, "Yes") = 13

 

[Serrre]

=COUNTIF(R5:R17, "Yes") = 13

Working,

Much appreciated!

 

[Serrre]

=COUNTIF(R5:R17, "Yes") = 13

Hey Alphafrog,

Now as you can see it says TRUE/FALSE depending on the drop down list.

Do you know how i make this a YES(=TRUE)/NO(=FALSE)

Thanks.

 

[Fluff]

Duplicate to: Drop down list automatic color

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.