Conditional formatting cell if every cell contains "YES"
Solved/Closed
LizzyDashwood
Posts
2
Registration date
Thursday April 30, 2015
Status
Member
Last seen
May 1, 2015
-
Apr 30, 2015 at 10:18 AM
LizzyDashwood Posts 2 Registration date Thursday April 30, 2015 Status Member Last seen May 1, 2015 - May 1, 2015 at 03:36 AM
LizzyDashwood Posts 2 Registration date Thursday April 30, 2015 Status Member Last seen May 1, 2015 - May 1, 2015 at 03:36 AM
Related:
- Conditional formatting cell if every cell contains "YES"
- If cell contains date then return value ✓ - Office Software Forum
- If cell contains specific text then return value in another cell ✓ - Excel Forum
- Excel conditional formatting if another cell contains specific text - Excel Forum
- Conditional formatting if two cells match ✓ - Excel Forum
- Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - Excel Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Apr 30, 2015 at 11:17 AM
Apr 30, 2015 at 11:17 AM
Hi Lizzy,
Try the following formula:
=COUNTIF($C1:$F1,"Yes")=4
Best regards,
Trowa
Try the following formula:
=COUNTIF($C1:$F1,"Yes")=4
Best regards,
Trowa
May 1, 2015 at 03:36 AM