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