Formula to completed fields

[Closed]
Report
-
Posts
2819
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 25, 2021
-
Hello,

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.

Thank you.

1 reply

Posts
2819
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 25, 2021
487
Hi Padvang,

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.

Best regards,
Trowa