Previous Topic Next Topic

Formula to completed fields

Closed
padvang - Feb 23, 2017 at 04:16 PM
TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 - Feb 27, 2017 at 11:28 AM
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

Answer 1 / 1
TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 541
Feb 27, 2017 at 11:28 AM
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
0