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
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Conditional formatting if cell contains text - Excel Forum
- Conditional formatting if two cells match ✓ - Excel Forum
- Apply conditional formatting to the selected cells ✓ - Excel Forum
- Highlight cell if another cell contains any text ✓ - Excel Forum
2 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
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