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: 2702
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: March 2, 2021

- 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
Conditional formatting to change cell color ✓ - Forum - Excel
Change cell color if condition fails - Forum - Excel
Excel vba change cell color based on value ✓ - Forum - Programming
How to change value based on cell color in excel ✓ - Forum - Office Software

1 reply

Ask a question

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

Answer 1 / 1

TrowaD

Posts: 2702
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: March 2, 2021

457
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

Cell Color Count with a condition [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!