Previous Topic Next Topic

Formula to completed fields

Closed
padvang - 23 Feb 2017 à 16:16
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 27 Feb 2017 à 11:28
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 response

Réponse 1 / 1
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
27 Feb 2017 à 11:28
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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
how to convert ounces (oz) to milliliter
JPortillo -
vcoolio -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses