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)