Conditional Formatting: Merged cell color
Solved/Closed
Ricky588
Posts
1
Registration date
Friday April 11, 2014
Status
Member
Last seen
April 11, 2014
-
Apr 11, 2014 at 02:28 PM
ricky588 - Apr 14, 2014 at 12:22 PM
ricky588 - Apr 14, 2014 at 12:22 PM
Related:
- Conditional formatting on merged cells
- Conditional formatting if cell contains text - Excel Forum
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Based on the values in cells b77 b81 ✓ - Excel Forum
- Clear only the formatting from the selected cell (leaving the content) - Guide
- Fill adjacent cell with number from text answer ✓ - Excel Forum
2 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Apr 14, 2014 at 11:08 AM
Apr 14, 2014 at 11:08 AM
Hi Ricky,
Try this formula:
=COUNTIF(G2:G4,"Complete")=3
Best regards,
Trowa
Try this formula:
=COUNTIF(G2:G4,"Complete")=3
Best regards,
Trowa