Formula to completed fields
Closed
padvang
-
Feb 23, 2017 at 04:16 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Feb 27, 2017 at 11:28 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Feb 27, 2017 at 11:28 AM
Related:
- Formula to completed fields
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Credit summation formula - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Feb 27, 2017 at 11:28 AM
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
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
