Highlight every fifth nonblank cells in column by conditional format

[Johnson Parayil]

Hi, I need the formula to highlight every 5th nonblank cells in a columns by conditional format . Sample screen shoot is attaching with message. Thank you in advance.

 

[Peter_SSs]

Try this. Select from D2 down and apply this CF rule

22 01 20.xlsm
	D
1	Qty
2
3	1
4	4
5	5
6	6
7	9
8	8
9
10
11	7
12	8
13	9
14
15	5
16	2
17	4
18
19	1
20	5
21	69
22	2
23
Every 5th

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D2:D23	Expression	=AND(MOD(COUNT(D$2:D2),5)=0,D2<>"")	text	NO

 

[Johnson Parayil]

Try this. Select from D2 down and apply this CF rule

22 01 20.xlsm
	D
1	Qty
2
3	1
4	4
5	5
6	6
7	9
8	8
9
10
11	7
12	8
13	9
14
15	5
16	2
17	4
18
19	1
20	5
21	69
22	2
23
Every 5th

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D2:D23	Expression	=AND(MOD(COUNT(D$2:D2),5)=0,D2<>"")	text	NO

Thank you so much Peter_SSs, It's working fine.
Regards
Johnson

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.