Conditional formating a group of values

[Kyndsberg]

Dear fellow Excel users

I'm trying to do conditional formating on a set of data. I want the background of the cells to reflect which cells belong together.

In the above example I want to switch between having a background colour and no background colour everytime the sum adds to zero.

The purpuse is to show which registrations are connected visually.

Any ideas? I'm trying match with indirect and row numbers based on the sum, but I'm still not getting quit getting the excact idea how to solve this.

Best regards

 

[JamesCanale]

MrExcelPlayground17.xlsx
	A	B	C	D
1	Date	Thing	Transaction	Running Sum
2	1/1/2023	a	$10,000	$10,000
3	1/2/2023	b	$1,000	$11,000
4	1/3/2023	c	-$6,000	$5,000
5	1/4/2023	d	$1,000	$6,000
6	1/5/2023	e	-$6,000	$0
7	1/6/2023	f	$100,000	$100,000
8	1/7/2023	g	-$25,000	$75,000
9	1/8/2023	h	$10,000	$85,000
10	1/9/2023	i	-$85,000	$0
11	1/10/2023	j	$5,000	$5,000
12	1/11/2023	k	-$5,000	$0
13	1/12/2023	l	$8,500	$8,500
14	1/13/2023	m	$7,500	$16,000
15	1/14/2023	n	-$16,000	$0
Sheet6

Cell Formulas
Range	Formula
A3:A15	A3	=A2+1
D2	D2	=C2
D3:D15	D3	=C3+D2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D2:D15	Expression	=ISEVEN(COUNTIF(D1:D$2,0))	text	NO

 

[Kyndsberg]

MrExcelPlayground17.xlsx
	A	B	C	D
1	Date	Thing	Transaction	Running Sum
2	1/1/2023	a	$10,000	$10,000
3	1/2/2023	b	$1,000	$11,000
4	1/3/2023	c	-$6,000	$5,000
5	1/4/2023	d	$1,000	$6,000
6	1/5/2023	e	-$6,000	$0
7	1/6/2023	f	$100,000	$100,000
8	1/7/2023	g	-$25,000	$75,000
9	1/8/2023	h	$10,000	$85,000
10	1/9/2023	i	-$85,000	$0
11	1/10/2023	j	$5,000	$5,000
12	1/11/2023	k	-$5,000	$0
13	1/12/2023	l	$8,500	$8,500
14	1/13/2023	m	$7,500	$16,000
15	1/14/2023	n	-$16,000	$0
Sheet6

Cell Formulas
Range	Formula
A3:A15	A3	=A2+1
D2	D2	=C2
D3:D15	D3	=C3+D2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D2:D15	Expression	=ISEVEN(COUNTIF(D1:D$2,0))	text	NO

Dear James Canale

Thank you so much - that's very clever.

I've never come across the "Is Even" function. I had to 'figgle' with it for a bit to understand what it's actually doing - that is very creative. Simply counting the total amount of zeros and every other zero will - off course - be an even number. It's exactly what i needed.

Have a nice day.

Kasper