Want to create a chronological row # then reset based on font color

Question

I want to create a column that numbers itself chronologically based on the column to its left based on font color. Then when a new font color appears in the column, I would like it to reset and then number the rows again. Pretty much create a line item column.

I found a code that kind of worked but it wasn't what I needed.

I tried other codes but nothing I found worked.

How is the data colored? Conditional Formatting or manually? Basically, what is rule that determines the change in colors? — Scott Craner, Feb 01 '23 at 18:24
Always helps to include the code you tried (even if it didn't work) — Tim Williams, Feb 01 '23 at 19:17

score 0 · Accepted Answer · answered Feb 01 '23 at 19:23

0

You could use this function to test the font color:

Option Explicit
Function TextColour(RG As Range)
    Application.Volatile
    TextColour = RG.Font.Color
End Function

Then use it like this:

Example:

answered Feb 01 '23 at 19:23

Cameron Critchlow

1,814
1
4
14

Does **not** work with conditional formatting. – Cameron Critchlow Feb 01 '23 at 19:24

Want to create a chronological row # then reset based on font color

1 Answers1

You could use this function to test the font color:

Then use it like this:

Example: