Auto Hide Rows in which multiple columns contain value of 0

[Jack3h]

Hello,

I am trying to figure out how to Auto hide rows in a table based on the criteria that Columns B,C,D & E contain a value of zero. (I also have another sheet that I would want to do the exact same thing but with B,C,D,E,F & G containing a value of zero). And if possible only on the rows that contain the tables.

The cells contain an IFERROR formula that returns a 0 if no data is fetched.

I'm assuming I will need to use a "Private Sub Worksheet_Calculate()" but so far all the ones I have tried have given me issues.

If possible I would also want it to Auto unhide the rows when the data is changed and the value in either of those columns is no longer Zero.

Is this a possible thing to do? This is my first post so bare with me if the explanation is not thorough enough.

Thanks!

C-Store Financial MCE test.xlsm
	A	B	C	D	E	F	G
5		November		November
6		2021		2020		Year over Year Difference
7	OTHER INCOME & EXPENSE	MONTH	YTD	MONTH	YTD	MONTH	YTD
8	FISHING/HUNTING LICENSE SALES	$ -	$ -	$ -	$ -	$ -	$ -
9	TRASH STICKERS SALES	$ -	$ -	$ -	$ -	$ -	$ -
10	RENTAL INCOME	$ -	$ -	$ -	$ -	$ -	$ -
11	ATM INCOME	$ 638.40	$ 6,823.40	$ 590.24	$ 6,521.64	$ 48.16	$ 301.76
12	MISCELLANEOUS INCOME	$ 727.27	$ 877.27	$ -	$ -	$ 727.27	$ 877.27
13	LOTTERY COMMISSIONS	$ 6,024.58	$ 61,136.54	$ 3,343.58	$ 45,630.99	$ 2,681.00	$ 15,505.55
14	PULL TABS COMMISSION	$ 1,200.00	$ 5,494.16	$ 959.04	$ 10,787.16	$ 240.96	$ (5,293.00)
15	PROMOTIONAL INCOME	$ 227.99	$ 5,538.93	$ 184.91	$ 1,837.64	$ 43.08	$ 3,701.29
16	TOBACCO PROMOTIONAL INCOME	$ 186.50	$ 20,371.41	$ 219.15	$ 4,250.00	$ (32.65)	$ 16,121.41
17	ENERGY/LIGHT ALLOWANCE INCOME	$ -	$ -	$ -	$ -	$ -	$ -
18	PHONE CARD GPM	$ 0.09	$ 5.33	$ 1.44	$ 45.96	$ (1.35)	$ (40.63)
19	COUPON HANDLING INCOME	$ -	$ 43.52	$ 10.24	$ 61.28	$ (10.24)	$ (17.76)
20	PHONE CARD SALES	$ 40.00	$ 884.99	$ 180.00	$ 1,305.00	$ (140.00)	$ (420.01)
21	GIFT CARD INCOME	$ 275.00	$ 3,120.00	$ 195.00	$ 1,385.00	$ 80.00	$ 1,735.00
22	GAIN/LOSS ON SALE OF ASSETS	$ -	$ -	$ -	$ -	$ -	$ -
23	OHIO SALES TAX DISCOUNT	$ 34.25	$ 391.23	$ 30.57	$ 363.97	$ 3.68	$ 27.26
24	FISHING/HUNTING LICENSE PURCHA	$ -	$ -	$ -	$ -	$ -	$ -
25	TRASH STICKERS PURCHASES	$ -	$ -	$ -	$ -	$ -	$ -
26	PHONE CARD EXPENSE	$ (40.00)	$ (884.99)	$ (180.00)	$ (1,305.00)	$ 140.00	$ 420.01
27	GIFT CARD EXPENSE	$ (275.00)	$ (3,345.00)	$ (220.00)	$ (1,600.00)	$ (55.00)	$ (1,745.00)
28	SALES TAX EXPENSE	$ 0.15	$ 13.72	$ (0.27)	$ 1.07	$ 0.42	$ 12.65
29	FUEL CLEANUP	$ (28.13)	$ 8,825.20	$ -	$ -	$ (28.13)	$ 8,825.20
30	INVOICE ERRORS	$ 0.12	$ 751.84	$ 0.36	$ 47.95	$ (0.24)	$ 703.89
31	TOTAL OTHER INCOME & EXPENSE	$ 9,011.22	$ 110,047.55	$ 5,314.26	$ 69,332.66	$ 3,696.96	$ 40,714.89
OTHER INC. EXP.

Cell Formulas
Range	Formula
B5:B6,D5:D6	B5	='Data-OH'!B18
B8:B30	B8	=IFERROR(INDEX('Data-OH'!B:B,MATCH(A8,'Data-OH'!A:A,0)),0)
C8:C30	C8	=IFERROR(INDEX('Data-OH'!C:C,MATCH(A8,'Data-OH'!A:A,0)),0)
D8:D30	D8	=IFERROR(INDEX('Data-OH'!D:D,MATCH(A8,'Data-OH'!A:A,0)),0)
E8:E30	E8	=IFERROR(INDEX('Data-OH'!E:E,MATCH(A8,'Data-OH'!A:A,0)),0)
F8:G30	F8	=B8-D8
B31	B31	=SUBTOTAL(109,[MONTH])
C31	C31	=SUBTOTAL(109,[YTD])
D31	D31	=SUBTOTAL(109,[[MONTH ]])
E31	E31	=SUBTOTAL(109,[[YTD ]])
F31	F31	=SUBTOTAL(109,[[MONTH ]])
G31	G31	=SUBTOTAL(109,[[YTD ]])

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
F8:G31	Cell Value	<0	text	NO
F8:G31	Cell Value	>0	text	NO

 

[Jack3h]

Nevermind, I have already come to a solution using a "Sub worksheet_change" function and some other formulas.