Hi,

The chapter count is simply
=COUNTIF(B:B,"Chapter *")-1

For the number of times in each chapter enter in D2
=IF(AND(B2<>"",B3=""),1,1+D1)

Use a conditional 'formula is' format on D2
=D2<D3
and set the font colour to white and copy D2 down

Regards