Provide Sequential Row Numbers

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

Are you colouring these cells manually? Is there perhaps some more simple logic that you could use to decide if a row has a title in it?

I guess another way is by checkin the Font...

But I do not know how to do it either...

And yes, I color them manually

Could you put the titles in a particular column or something like that? Then you could test to see if there was an entry?