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

 

[Micron]

I managed to get this CF formula to work across a row, so you would need to alter the range (T?:T?) and the count value (13?)
=COUNTIF(C3:K3,"x")=9

My question marks are because I can't tell what your row numbers are. This suggestion is based on what looks like a static range of 13 values. If the count is dynamic, then a fixed number probably won't work for you. You'll also need to use Yes (or no as the case may be) and not "x" as I did. I didn't test to see if the case of the searched value matters (e.g. Yes vs yes vs YES)

 

[Asbestos_Jen]

For conditional formatting the cell that currently says FALSE (G11?), try the below, with T5:T17 replaced as needed to match your actual data range

=countif(T5:T17,"yes")=counta(T5:T17)

 

[Serrre]

I managed to get this CF formula to work across a row, so you would need to alter the range (T?:T?) and the count value (13?)
=COUNTIF(C3:K3,"x")=9

My question marks are because I can't tell what your row numbers are. This suggestion is based on what looks like a static range of 13 values. If the count is dynamic, then a fixed number probably won't work for you. You'll also need to use Yes (or no as the case may be) and not "x" as I did. I didn't test to see if the case of the searched value matters (e.g. Yes vs yes vs YES)

Hey Micron, thanks.

It is counting the amount of times it says 'Yes' now, but how do i make it so it automatically turns a green color now?

 

[Serrre]

For conditional formatting the cell that currently says FALSE (G11?), try the below, with T5:T17 replaced as needed to match your actual data range

=countif(T5:T17,"yes")=counta(T5:T17)

Hey Asbestos_Jen, Thanks!

The formula now gives a ''TRUE'' instead of FALSE, but how do i now make it a green color?

 

[Micron]

My formula is a CF formula (Conditional Formatting). I suspect you only used it as a cell formula on G13. You must create a CF rule for G13 and the other cells and use that formula or a version of it for the other cells.

 

[Asbestos_Jen]

As with @Micron's answer, you need to put it into a conditional formatting rule.

 

[Serrre]

My formula is a CF formula (Conditional Formatting). I suspect you only used it as a cell formula on G13. You must create a CF rule for G13 and the other cells and use that formula or a version of it for the other cells.

It is working now.

Now is it possible to make it so it will say something else instead of True/False like Yes/no?

thanks for your time,

 

[Micron]

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.

 

[Asbestos_Jen]

For the formula I gave you in post #3, change G11 to:

=if(countif(T5:T17,"yes")=counta(T5:T17),"Yes","No")