Posts by Nick_James

Re: Simply count the colored cells per row

That was it!!!! Thank you guys so much for helping me with this. It works perfectly just how I dreamed it would, and this is going to save me from adding each row manually, and make my life so much easier. Amazing.

Re: Simply count the colored cells per row

Quote from yegarboy;694309

This will do what you want. It assumes your Blue is the Excel default blue. AKA "vbBlue".

Code

Private Sub Worksheet_SelectionChange(ByVal Target As Range)


  Dim i  As Integer
    Dim j As Integer


  Range("O4:O33").ClearContents


    For i = 4 To 33 'Rows
        For j = 2 To 14 'Col
           If ActiveSheet.Cells(i, j).Interior.Color = vbBlue Then
            Range("O" & i).Value = Range("O" & i).Value + 1 'Count number of blue cells per row
            End If
            
        Next j
    Next i




 
End Sub

Display More

Ok so after I create a module in VBE, how do I get it to work? Do I need to use it as a function?

I'm using Excel 2003. All I need to do is have the cells in the O column count the number of cells I have manually changed to the color of per row. I'll be changing the color to blue in the range of B4 to N33. I'm a self taught Excel user, and this is the first time I've attempted something this complex. Thanks.