Excel conditional formatting
Solved/Closed
Related:
- Excel conditional formatting
- Excel conditional formatting 5 color scale ✓ - Forum - Excel
- Excel conditional formatting if another cell contains specific text ✓ - Forum - Excel
- Excel conditional formatting entire column based on another column ✓ - Forum - Excel
- Excel conditional formatting if another cell contains any text ✓ - Forum - Excel
- Excel conditional formatting hyperlink ✓ - Forum - Excel
1 reply
rizvisa1
Jun 4, 2010 at 06:11 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Jun 4, 2010 at 06:11 PM
apply format where ?
could you explain a bit more
could you explain a bit more
Jun 5, 2010 at 04:45 PM
Jun 5, 2010 at 05:18 PM
Enter this formula
=COUNTIF(B1:B30,"=" & A1)>0
In the conditional format dialogbox, click on format and choose the color
Jun 7, 2010 at 11:05 AM