If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Visible Rows, Dynamic Row Numbering, Conditional Formatting, and Formulas

Thread starter Jeffrey Mahoney
Start date Apr 29, 2024

Overview Discussion

Jeffrey Mahoney

Well-known Member

Apr 29, 2024

Jeffrey Mahoney submitted a new Excel article:

Visible Rows, Dynamic Row Numbering, Conditional Formatting, and Formulas - Use Visible Rows for dynamic row numbers, conditional formatting every other row.

Using Subtotal on every row of your range table, you can display sequential row numbers for visible rows only. With that you can also fill every other row with a cell color just like a defined Excel Table even when rows are filtered. You can also use ****IFS functions to get results for visible rows only.

Dynamic Row Numbering
The Key to the whole thing is the formula in cell A3. It shows a row number only if the row is visible (not filtered out)...