Cell Color Count with a condition [Closed]

Question

Cell Color Count with a condition [Closed]

Report

Manu - Apr 2, 2017 at 08:53 AM
TrowaD

Posts: 2670
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: October 22, 2020

- Apr 3, 2017 at 11:39 AM

Hello,

I need a help.

I need to count cells in a range having a specific color (In one column) & cells in a range having a text (In another column).

I have already used VBA code for counting colored cells seperately. But I'm not getting correct

I'm desperately in need of help.

Cell Color Count with a condition
Conditional Formatting: Merged cell color ✓ - Forum - Excel
Excel conditional formatting based on another cell color ✓ - Forum - Excel
Change cell color if condition fails - Forum - Excel
Excel if cell color is red then - How-To - Excel
Excel vba change cell color based on value ✓ - Forum - Programming

1 reply

Ask a question

TrowaD · Answer 1 · 2017-04-03T11:39:15-0400

Answer 1 / 1

TrowaD

Posts: 2670
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: October 22, 2020

446
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:

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

Your reply