Conditional formatting to compare rows on a form

[william barker]

I am looking for code to allow me to compare the entry in each cell to the previous day to look for any anomalies in the data feeds each day. Something to the effect, that if the values are greater than 50% change versus the previous day, the values would be conditionally formatted in red (not text necessarily, but filled)

Date	CountOfPART NUMBER	SumOfMONTH TO BLD-M1	SumOfMONTH TO BLD-M2	SumOfMONTH TO BLD-M3	SumOfMONTH TO BLD-M4	SumOfMONTH TO BLD-M5	SumOfMONTH TO BLD-M6	SumOfMONTH TO BLD-M7	SumOfMONTH TO BLD-M8	SumOfMONTH TO BLD-M9	SumOfMONTH TO BLD-M10	SumOfMONTH TO BLD-M11	SumOfMONTH TO BLD-M12	SumOfMONTH TO BLD-M13	SumOfMONTH TO BLD-M14	SumOfMONTH TO BLD-M15	SumOfMONTH TO BLD-M16	SumOfMONTH TO BLD-M17	SumOfMONTH TO BLD-M18
1/3/2017 11:45:16 AM	6823	280,037.00	304,835.00	417,282.00	353,843.00	419,087.00	339,246.00	371,821.00	426,809.00	363,115.00	344,557.00	414,218.00	347,791.00	420,020.00	335,204.00	356,620.00	339,513.00	364,149.00	109,348.00
1/2/2017 9:44:11 AM	662	50,124.00	53,638.00	71,914.00	59,694.00	70,502.00	55,379.00	55,802.00	69,548.00	56,512.00	56,190.00	70,979.00	56,032.00	71,946.00	55,908.00	57,976.00	55,398.00	59,352.00	20,548.00
12/30/2016 6:50:33 AM	6797	297,759.00	287,185.00	297,439.00	368,840.00	296,987.00	291,077.00	409,776.00	296,254.00	360,574.00	298,389.00	295,643.00	356,282.00	296,675.00	289,958.00	284,131.00	311,368.00	98,471.00	0.00
12/29/2016 7:35:10 AM	6798	344,127.00	290,163.00	298,512.00	372,738.00	291,899.00	298,096.00	407,199.00	296,595.00	294,875.00	364,716.00	294,175.00	292,080.00	358,265.00	294,350.00	282,674.00	312,103.00	96,526.00	0.00
12/28/2016 8:29:32 AM	6798	348,041.00	291,636.00	296,844.00	304,688.00	360,669.00	296,167.00	340,503.00	361,355.00	298,342.00	364,653.00	294,429.00	291,517.00	357,648.00	293,444.00	282,237.00	314,572.00	97,015.00	0.00
12/27/2016 8:37:10 AM	6796	285,473.00	348,660.00	297,101.00	310,586.00	360,127.00	295,624.00	342,579.00	360,244.00	297,300.00	297,694.00	357,421.00	295,032.00	358,809.00	295,150.00	282,145.00	260,418.00	149,816.00	0.00

[aytee111]

You need the information all on one line - a hidden field that has already read and processed the next date and has a y/n for > 50%. The best way is to do it in VBA and create a temp table with the data when opening this form. It can also be done with queries.