Hello

Im kinda new to excel. I am trying to provide sequential numbers to my worksheet rows.

However, I would like my function to exclude rows that contain titles (the rows with titles are colored).

So I've heard I need to use :


Function IntColor(myrange As Range)
IntColor = myrange.Interior.ColorIndex
End Function

Im not sure how to implement it.

I tried writing as follows- in the first cell in the first row (cell A4):

=IF((Function IntColor(myrange As Range)
IntColor = myrange.Interior.ColorIndex
End Function
),ROWS($A$4:A4),"")

I also don't know how to determine which color nmber I am using in my titles.

Do my question make any sense? Please be gentle -remember I am new to excel so try to porvide a simple answer