Cell Color Count with a condition
Closed
Manu
-
Apr 2, 2017 at 08:53 AM
TrowaD
TrowaD
- Posts
- 2884
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 21, 2022
Related:
- Cell Color Count with a condition
- Count if cell color conditional formatting - Forum - Excel
- Conditional Formatting: Merged cell color ✓ - Forum - Excel
- Excel formula to change cell color based on text without conditional formatting ✓ - Forum - Excel
- Conditional formatting excel cell color based on text in another cell ✓ - Forum - Excel
- Excel formula to change cell color without conditional formatting - Forum - Excel
1 reply
TrowaD
Apr 3, 2017 at 11:39 AM
- Posts
- 2884
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 21, 2022
Apr 3, 2017 at 11:39 AM
Hi manu,
You didn't provide any specifics, but use the following code to count the number of yellow cells in the range A1:A10:
Use the macro recorder to find the color code for other colors.
To count cell with specific text, you can use a formula:
=COUNTIF(B1:B10;"MyText")
Best regards,
Trowa
You didn't provide any specifics, but use the following code to count the number of yellow cells in the range A1:A10:
Sub RunMe() Dim x As Integer For Each cell In Range("A1:A10") If cell.Interior.Color = 65535 Then x = x + 1 End If Next cell MsgBox "There are " & x & " yellow cells." End Sub
Use the macro recorder to find the color code for other colors.
To count cell with specific text, you can use a formula:
=COUNTIF(B1:B10;"MyText")
Best regards,
Trowa