I need a formula to look up values that if it shows all false it's a green light and if it contains at least 1 true value, it's red light. I'm creating a form that will show a user if the form is completely filled out or if fields still needs to be completed.
You didn't provide any ranges, so let's say A1:C1 is filled with either TRUE or FALSE.
Then color these cells green and while these cells are selected go to conditional formatting. Choose to use a formula:
=COUNTIF($A1:$C1,TRUE)=3
Format will be red.
When all 3 cells show TRUE then the color will be red otherwise they are green.
Not sure if this is what you are after, but the best I can do with the given description.
