Highlight 14th Consecutive non-empty cell

While I look at this, please update your profile NOW to show:

1) your approximate location (country is perfect), and

2) the Excel version you are currently using (e.g. O365 for PC, 2021 for Mac, etc).

OK. first attempt!

1. Introduce an EMPTY column at column D.

2. Set up a Named range (CTRL-F3), called CF:
=MOD(1/(1/COUNTIF(INDEX($D2:E2,AGGREGATE(14,6,(COLUMN($D2:E2)-COLUMN($D2)+1)/($D2:E2=0),1)):E2,">0")),14)=0

3. Then use =CF as the formula for conditional formatting.

An other option:

Please try in your file the following conditional formatting rule applies to $D$2:$AU$5

Formula:

Please Login or Register  to view this content.

(In the attached file is the range $D$7:$AU$10).

Thank you @Glenn Kennedy, your solution worked very well. Thanks for your time and support.

@HansDouwe, your solution isn't returning the desired results. its highlighting 14th consecutive cell, however if we delete/remove value from one cell in between these consecutive cells, the highlight stays till we delete more than one cell's values.

You're welcome and thanks for the feedback.

Thx for your feedback.

I've corrected my formula:

Please try in your file the following conditional formatting rule applies to $D$2:$AU$5

Formula:

Please Login or Register  to view this content.

In the attached workbook the formula applies to $D$7:$AU$10.