Colouring Blank cells

M

melbin

New Member
Joined
Oct 17, 2017
Messages
8
What should be the formula to color blank cells yellow using conditional formatting. "" symbol is not working..
Can anyone help me please
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
Sort by date Sort by votes
[TABLE="width: 1066"]
<tbody>[TR]
[TD]6/11/2017[/TD]
[TD="align: right"]$0[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]$30[/TD]
[TD="align: right"]50%[/TD]
[TD="align: right"]$105[/TD]
[TD="align: right"]45%[/TD]
[TD="align: right"]$4,802[/TD]
[TD="align: right"]154%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$4,937[/TD]
[TD="align: right"]133%[/TD]
[/TR]
[TR]
[TD]6/18/2017[/TD]
[TD="align: right"]$248[/TD]
[TD][/TD]
[TD="align: right"]$7[/TD]
[TD="align: right"]23%[/TD]
[TD="align: right"]$549[/TD]
[TD="align: right"]524%[/TD]
[TD="align: right"]$5,534[/TD]
[TD="align: right"]115%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$6,339[/TD]
[TD="align: right"]128%[/TD]
[/TR]
[TR]
[TD]6/25/2017[/TD]
[TD="align: right"]$217[/TD]
[TD="align: right"]87%[/TD]
[TD="align: right"]$30[/TD]
[TD="align: right"]429%[/TD]
[TD="align: right"]$323[/TD]
[TD="align: right"]59%[/TD]
[TD="align: right"]$7,458[/TD]
[TD="align: right"]135%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$8,028[/TD]
[TD="align: right"]127%[/TD]
[/TR]
[TR]
[TD]7/2/2017[/TD]
[TD="align: right"]$220[/TD]
[TD="align: right"]101%[/TD]
[TD="align: right"]$45[/TD]
[TD="align: right"]150%[/TD]
[TD="align: right"]$371[/TD]
[TD="align: right"]115%[/TD]
[TD="align: right"]$8,658[/TD]
[TD="align: right"]116%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$9,294[/TD]
[TD="align: right"]116%[/TD]
[/TR]
[TR]
[TD]7/9/2017[/TD]
[TD="align: right"]$0[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]$0[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]$328[/TD]
[TD="align: right"]88%[/TD]
[TD="align: right"]$7,062[/TD]
[TD="align: right"]82%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$7,390[/TD]
[TD="align: right"]80%[/TD]
[/TR]
[TR]
[TD]7/16/2017[/TD]
[TD="align: right"]$315[/TD]
[TD][/TD]
[TD="align: right"]$60[/TD]
[TD][/TD]
[TD="align: right"]$621[/TD]
[TD="align: right"]189%[/TD]
[TD="align: right"]$6,903[/TD]
[TD="align: right"]98%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$7,899[/TD]
[TD="align: right"]107%[/TD]
[/TR]
[TR]
[TD]7/23/2017[/TD]
[TD="align: right"]$396[/TD]
[TD="align: right"]126%[/TD]
[TD="align: right"]$45[/TD]
[TD="align: right"]75%[/TD]
[TD="align: right"]$554[/TD]
[TD="align: right"]89%[/TD]
[TD="align: right"]$7,471[/TD]
[TD="align: right"]108%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$8,465[/TD]
[TD="align: right"]107%[/TD]
[/TR]
[TR]
[TD]7/30/2017[/TD]
[TD="align: right"]$418[/TD]
[TD="align: right"]106%[/TD]
[TD="align: right"]$45[/TD]
[TD="align: right"]100%[/TD]
[TD="align: right"]$784[/TD]
[TD="align: right"]142%[/TD]
[TD="align: right"]$10,898[/TD]
[TD="align: right"]146%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$12,146[/TD]
[TD="align: right"]143%[/TD]
[/TR]
[TR]
[TD]8/6/2017[/TD]
[TD="align: right"]$438[/TD]
[TD="align: right"]105%[/TD]
[TD="align: right"]$29[/TD]
[TD="align: right"]64%[/TD]
[TD="align: right"]$444[/TD]
[TD="align: right"]57%[/TD]
[TD="align: right"]$5,629[/TD]
[TD="align: right"]52%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$6,540[/TD]
[TD="align: right"]54%[/TD]
[/TR]
[TR]
[TD]8/13/2017[/TD]
[TD="align: right"]$473[/TD]
[TD="align: right"]108%[/TD]
[TD="align: right"]$23[/TD]
[TD="align: right"]79%[/TD]
[TD="align: right"]$461[/TD]
[TD="align: right"]104%[/TD]
[TD="align: right"]$7,110[/TD]
[TD="align: right"]126%[/TD]
[TD="align: right"]$527[/TD]
[TD][/TD]
[TD="align: right"]$0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$8,594[/TD]
[TD="align: right"]131%[/TD]
[/TR]
[TR]
[TD]8/20/2017[/TD]
[TD="align: right"]$482[/TD]
[TD="align: right"]102%[/TD]
[TD="align: right"]$30[/TD]
[TD="align: right"]130%[/TD]
[TD="align: right"]$237[/TD]
[TD="align: right"]51%[/TD]
[TD="align: right"]$5,787[/TD]
[TD="align: right"]81%[/TD]
[TD="align: right"]$450[/TD]
[TD="align: right"]85%[/TD]
[TD="align: right"]$749[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$7,735[/TD]
[TD="align: right"]90%[/TD]
[/TR]
[TR]
[TD]8/27/2017[/TD]
[TD="align: right"]$416[/TD]
[TD="align: right"]86%[/TD]
[TD="align: right"]$45[/TD]
[TD="align: right"]150%[/TD]
[TD="align: right"]$384[/TD]
[TD="align: right"]162%[/TD]
[TD="align: right"]$8,120[/TD]
[TD="align: right"]140%[/TD]
[TD="align: right"]$338[/TD]
[TD="align: right"]75%[/TD]
[TD="align: right"]$729[/TD]
[TD="align: right"]97%[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$10,032[/TD]
[TD="align: right"]130%[/TD]
[/TR]
[TR]
[TD]9/3/2017[/TD]
[TD="align: right"]$495[/TD]
[TD="align: right"]119%[/TD]
[TD="align: right"]$128[/TD]
[TD="align: right"]284%[/TD]
[TD="align: right"]$177[/TD]
[TD="align: right"]46%[/TD]
[TD="align: right"]$8,241[/TD]
[TD="align: right"]101%[/TD]
[TD="align: right"]$307[/TD]
[TD="align: right"]91%[/TD]
[TD="align: right"]$691[/TD]
[TD="align: right"]95%[/TD]
[TD="align: right"]$436[/TD]
[TD][/TD]
[TD="align: right"]$10,475[/TD]
[TD="align: right"]104%[/TD]
[/TR]
[TR]
[TD]9/10/2017[/TD]
[TD="align: right"]$322[/TD]
[TD="align: right"]65%[/TD]
[TD="align: right"]$45[/TD]
[TD="align: right"]35%[/TD]
[TD="align: right"]$357[/TD]
[TD="align: right"]201%[/TD]
[TD="align: right"]$6,656[/TD]
[TD="align: right"]81%[/TD]
[TD="align: right"]$312[/TD]
[TD="align: right"]102%[/TD]
[TD="align: right"]$793[/TD]
[TD="align: right"]115%[/TD]
[TD="align: right"]$488[/TD]
[TD="align: right"]112%[/TD]
[TD="align: right"]$8,973[/TD]
[TD="align: right"]86%[/TD]
[/TR]
[TR]
[TD]9/17/2017[/TD]
[TD="align: right"]$312[/TD]
[TD="align: right"]97%[/TD]
[TD="align: right"]$31[/TD]
[TD="align: right"]69%[/TD]
[TD="align: right"]$291[/TD]
[TD="align: right"]81%[/TD]
[TD="align: right"]$6,720[/TD]
[TD="align: right"]101%[/TD]
[TD="align: right"]$326[/TD]
[TD="align: right"]104%[/TD]
[TD="align: right"]$656[/TD]
[TD="align: right"]83%[/TD]
[TD="align: right"]$374[/TD]
[TD="align: right"]77%[/TD]
[TD="align: right"]$8,708[/TD]
[TD="align: right"]97%[/TD]
[/TR]
[TR]
[TD]9/24/2017[/TD]
[TD="align: right"]$392[/TD]
[TD="align: right"]125%[/TD]
[TD="align: right"]$63[/TD]
[TD="align: right"]203%[/TD]
[TD="align: right"]$185[/TD]
[TD="align: right"]64%[/TD]
[TD="align: right"]$8,252[/TD]
[TD="align: right"]123%[/TD]
[TD="align: right"]$351[/TD]
[TD="align: right"]108%[/TD]
[TD="align: right"]$973[/TD]
[TD="align: right"]148%[/TD]
[TD="align: right"]$551[/TD]
[TD="align: right"]148%[/TD]
[TD="align: right"]$10,767[/TD]
[TD="align: right"]124%[/TD]
[/TR]
[TR]
[TD]10/1/2017[/TD]
[TD="align: right"]$366[/TD]
[TD="align: right"]94%[/TD]
[TD="align: right"]$31[/TD]
[TD="align: right"]49%[/TD]
[TD="align: right"]$251[/TD]
[TD="align: right"]135%[/TD]
[TD="align: right"]$6,234[/TD]
[TD="align: right"]76%[/TD]
[TD="align: right"]$367[/TD]
[TD="align: right"]105%[/TD]
[TD="align: right"]$873[/TD]
[TD="align: right"]90%[/TD]
[TD="align: right"]$483[/TD]
[TD="align: right"]88%[/TD]
[TD="align: right"]$8,605[/TD]
[TD="align: right"]80%[/TD]
[/TR]
[TR]
[TD]10/8/2017[/TD]
[TD="align: right"]$540[/TD]
[TD="align: right"]147%[/TD]
[TD="align: right"]$16[/TD]
[TD="align: right"]52%[/TD]
[TD="align: right"]$138[/TD]
[TD="align: right"]55%[/TD]
[TD="align: right"]$6,697[/TD]
[TD="align: right"]107%[/TD]
[TD="align: right"]$376[/TD]
[TD="align: right"]102%[/TD]
[TD="align: right"]$1,030[/TD]
[TD="align: right"]118%[/TD]
[TD="align: right"]$425[/TD]
[TD="align: right"]88%[/TD]
[TD="align: right"]$9,223[/TD]
[TD="align: right"]107%[/TD]
[/TR]
[TR]
[TD]10/15/2017[/TD]
[TD="align: right"]$551[/TD]
[TD="align: right"]102%[/TD]
[TD="align: right"]$41[/TD]
[TD="align: right"]256%[/TD]
[TD="align: right"]$198[/TD]
[TD="align: right"]143%[/TD]
[TD="align: right"]$6,865[/TD]
[TD="align: right"]103%[/TD]
[TD="align: right"]$379[/TD]
[TD="align: right"]101%[/TD]
[TD="align: right"]$1,889[/TD]
[TD="align: right"]183%[/TD]
[TD="align: right"]$723[/TD]
[TD="align: right"]170%[/TD]
[TD="align: right"]$10,644[/TD]
[TD="align: right"]115%[/TD]
[/TR]
[TR]
[TD]10/22/2017[/TD]
[TD="align: right"]$572[/TD]
[TD="align: right"]104%[/TD]
[TD="align: right"]$69[/TD]
[TD="align: right"]168%[/TD]
[TD="align: right"]$180[/TD]
[TD="align: right"]91%[/TD]
[TD="align: right"]$7,000[/TD]
[TD="align: right"]102%[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$5,400[/TD]
[TD="align: right"]286%[/TD]
[TD="align: right"]$1,500[/TD]
[TD="align: right"]207%[/TD]
[TD="align: right"]$14,721[/TD]
[TD="align: right"]138%[/TD]
[/TR]
[TR]
[TD]10/29/2017[/TD]
[TD="align: right"]$473[/TD]
[TD="align: right"]83%[/TD]
[TD="align: right"]$23[/TD]
[TD="align: right"]33%[/TD]
[TD="align: right"]$461[/TD]
[TD="align: right"]256%[/TD]
[TD="align: right"]$7,110[/TD]
[TD="align: right"]102%[/TD]
[TD="align: right"]$527[/TD]
[TD][/TD]
[TD="align: right"]$0[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]$8,999[/TD]
[TD="align: right"]600%[/TD]
[TD="align: right"]$17,593[/TD]
[TD="align: right"]120%[/TD]
[/TR]
[TR]
[TD]Grand Total[/TD]
[TD="align: right"]$13,723[/TD]
[TD][/TD]
[TD="align: right"]$1,868[/TD]
[TD][/TD]
[TD="align: right"]$11,041[/TD]
[TD][/TD]
[TD="align: right"]$183,343[/TD]
[TD][/TD]
[TD="align: right"]$4,259[/TD]
[TD][/TD]
[TD="align: right"]$13,783[/TD]
[TD][/TD]
[TD="align: right"]$13,979[/TD]
[TD][/TD]
[TD="align: right"]$241,996[/TD]
[TD][TABLE="width: 1066"]
<tbody>[TR]
[TD]6/11/2017[/TD]
[TD="align: right"]$0[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]$30[/TD]
[TD="align: right"]50%[/TD]
[TD="align: right"]$105[/TD]
[TD="align: right"]45%[/TD]
[TD="align: right"]$4,802[/TD]
[TD="align: right"]154%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$4,937[/TD]
[TD="align: right"]133%[/TD]
[/TR]
[TR]
[TD]6/18/2017[/TD]
[TD="align: right"]$248[/TD]
[TD][/TD]
[TD="align: right"]$7[/TD]
[TD="align: right"]23%[/TD]
[TD="align: right"]$549[/TD]
[TD="align: right"]524%[/TD]
[TD="align: right"]$5,534[/TD]
[TD="align: right"]115%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$6,339[/TD]
[TD="align: right"]128%[/TD]
[/TR]
[TR]
[TD]6/25/2017[/TD]
[TD="align: right"]$217[/TD]
[TD="align: right"]87%[/TD]
[TD="align: right"]$30[/TD]
[TD="align: right"]429%[/TD]
[TD="align: right"]$323[/TD]
[TD="align: right"]59%[/TD]
[TD="align: right"]$7,458[/TD]
[TD="align: right"]135%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$8,028[/TD]
[TD="align: right"]127%[/TD]
[/TR]
[TR]
[TD]7/2/2017[/TD]
[TD="align: right"]$220[/TD]
[TD="align: right"]101%[/TD]
[TD="align: right"]$45[/TD]
[TD="align: right"]150%[/TD]
[TD="align: right"]$371[/TD]
[TD="align: right"]115%[/TD]
[TD="align: right"]$8,658[/TD]
[TD="align: right"]116%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$9,294[/TD]
[TD="align: right"]116%[/TD]
[/TR]
[TR]
[TD]7/9/2017[/TD]
[TD="align: right"]$0[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]$0[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]$328[/TD]
[TD="align: right"]88%[/TD]
[TD="align: right"]$7,062[/TD]
[TD="align: right"]82%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$7,390[/TD]
[TD="align: right"]80%[/TD]
[/TR]
[TR]
[TD]7/16/2017[/TD]
[TD="align: right"]$315[/TD]
[TD][/TD]
[TD="align: right"]$60[/TD]
[TD][/TD]
[TD="align: right"]$621[/TD]
[TD="align: right"]189%[/TD]
[TD="align: right"]$6,903[/TD]
[TD="align: right"]98%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$7,899[/TD]
[TD="align: right"]107%[/TD]
[/TR]
[TR]
[TD]7/23/2017[/TD]
[TD="align: right"]$396[/TD]
[TD="align: right"]126%[/TD]
[TD="align: right"]$45[/TD]
[TD="align: right"]75%[/TD]
[TD="align: right"]$554[/TD]
[TD="align: right"]89%[/TD]
[TD="align: right"]$7,471[/TD]
[TD="align: right"]108%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$8,465[/TD]
[TD="align: right"]107%[/TD]
[/TR]
[TR]
[TD]7/30/2017[/TD]
[TD="align: right"]$418[/TD]
[TD="align: right"]106%[/TD]
[TD="align: right"]$45[/TD]
[TD="align: right"]100%[/TD]
[TD="align: right"]$784[/TD]
[TD="align: right"]142%[/TD]
[TD="align: right"]$10,898[/TD]
[TD="align: right"]146%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$12,146[/TD]
[TD="align: right"]143%[/TD]
[/TR]
[TR]
[TD]8/6/2017[/TD]
[TD="align: right"]$438[/TD]
[TD="align: right"]105%[/TD]
[TD="align: right"]$29[/TD]
[TD="align: right"]64%[/TD]
[TD="align: right"]$444[/TD]
[TD="align: right"]57%[/TD]
[TD="align: right"]$5,629[/TD]
[TD="align: right"]52%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$6,540[/TD]
[TD="align: right"]54%[/TD]
[/TR]
[TR]
[TD]8/13/2017[/TD]
[TD="align: right"]$473[/TD]
[TD="align: right"]108%[/TD]
[TD="align: right"]$23[/TD]
[TD="align: right"]79%[/TD]
[TD="align: right"]$461[/TD]
[TD="align: right"]104%[/TD]
[TD="align: right"]$7,110[/TD]
[TD="align: right"]126%[/TD]
[TD="align: right"]$527[/TD]
[TD][/TD]
[TD="align: right"]$0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$8,594[/TD]
[TD="align: right"]131%[/TD]
[/TR]
[TR]
[TD]8/20/2017[/TD]
[TD="align: right"]$482[/TD]
[TD="align: right"]102%[/TD]
[TD="align: right"]$30[/TD]
[TD="align: right"]130%[/TD]
[TD="align: right"]$237[/TD]
[TD="align: right"]51%[/TD]
[TD="align: right"]$5,787[/TD]
[TD="align: right"]81%[/TD]
[TD="align: right"]$450[/TD]
[TD="align: right"]85%[/TD]
[TD="align: right"]$749[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$7,735[/TD]
[TD="align: right"]90%[/TD]
[/TR]
[TR]
[TD]8/27/2017[/TD]
[TD="align: right"]$416[/TD]
[TD="align: right"]86%[/TD]
[TD="align: right"]$45[/TD]
[TD="align: right"]150%[/TD]
[TD="align: right"]$384[/TD]
[TD="align: right"]162%[/TD]
[TD="align: right"]$8,120[/TD]
[TD="align: right"]140%[/TD]
[TD="align: right"]$338[/TD]
[TD="align: right"]75%[/TD]
[TD="align: right"]$729[/TD]
[TD="align: right"]97%[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$10,032[/TD]
[TD="align: right"]130%[/TD]
[/TR]
[TR]
[TD]9/3/2017[/TD]
[TD="align: right"]$495[/TD]
[TD="align: right"]119%[/TD]
[TD="align: right"]$128[/TD]
[TD="align: right"]284%[/TD]
[TD="align: right"]$177[/TD]
[TD="align: right"]46%[/TD]
[TD="align: right"]$8,241[/TD]
[TD="align: right"]101%[/TD]
[TD="align: right"]$307[/TD]
[TD="align: right"]91%[/TD]
[TD="align: right"]$691[/TD]
[TD="align: right"]95%[/TD]
[TD="align: right"]$436[/TD]
[TD][/TD]
[TD="align: right"]$10,475[/TD]
[TD="align: right"]104%[/TD]
[/TR]
[TR]
[TD]9/10/2017[/TD]
[TD="align: right"]$322[/TD]
[TD="align: right"]65%[/TD]
[TD="align: right"]$45[/TD]
[TD="align: right"]35%[/TD]
[TD="align: right"]$357[/TD]
[TD="align: right"]201%[/TD]
[TD="align: right"]$6,656[/TD]
[TD="align: right"]81%[/TD]
[TD="align: right"]$312[/TD]
[TD="align: right"]102%[/TD]
[TD="align: right"]$793[/TD]
[TD="align: right"]115%[/TD]
[TD="align: right"]$488[/TD]
[TD="align: right"]112%[/TD]
[TD="align: right"]$8,973[/TD]
[TD="align: right"]86%[/TD]
[/TR]
[TR]
[TD]9/17/2017[/TD]
[TD="align: right"]$312[/TD]
[TD="align: right"]97%[/TD]
[TD="align: right"]$31[/TD]
[TD="align: right"]69%[/TD]
[TD="align: right"]$291[/TD]
[TD="align: right"]81%[/TD]
[TD="align: right"]$6,720[/TD]
[TD="align: right"]101%[/TD]
[TD="align: right"]$326[/TD]
[TD="align: right"]104%[/TD]
[TD="align: right"]$656[/TD]
[TD="align: right"]83%[/TD]
[TD="align: right"]$374[/TD]
[TD="align: right"]77%[/TD]
[TD="align: right"]$8,708[/TD]
[TD="align: right"]97%[/TD]
[/TR]
[TR]
[TD]9/24/2017[/TD]
[TD="align: right"]$392[/TD]
[TD="align: right"]125%[/TD]
[TD="align: right"]$63[/TD]
[TD="align: right"]203%[/TD]
[TD="align: right"]$185[/TD]
[TD="align: right"]64%[/TD]
[TD="align: right"]$8,252[/TD]
[TD="align: right"]123%[/TD]
[TD="align: right"]$351[/TD]
[TD="align: right"]108%[/TD]
[TD="align: right"]$973[/TD]
[TD="align: right"]148%[/TD]
[TD="align: right"]$551[/TD]
[TD="align: right"]148%[/TD]
[TD="align: right"]$10,767[/TD]
[TD="align: right"]124%[/TD]
[/TR]
[TR]
[TD]10/1/2017[/TD]
[TD="align: right"]$366[/TD]
[TD="align: right"]94%[/TD]
[TD="align: right"]$31[/TD]
[TD="align: right"]49%[/TD]
[TD="align: right"]$251[/TD]
[TD="align: right"]135%[/TD]
[TD="align: right"]$6,234[/TD]
[TD="align: right"]76%[/TD]
[TD="align: right"]$367[/TD]
[TD="align: right"]105%[/TD]
[TD="align: right"]$873[/TD]
[TD="align: right"]90%[/TD]
[TD="align: right"]$483[/TD]
[TD="align: right"]88%[/TD]
[TD="align: right"]$8,605[/TD]
[TD="align: right"]80%[/TD]
[/TR]
[TR]
[TD]10/8/2017[/TD]
[TD="align: right"]$540[/TD]
[TD="align: right"]147%[/TD]
[TD="align: right"]$16[/TD]
[TD="align: right"]52%[/TD]
[TD="align: right"]$138[/TD]
[TD="align: right"]55%[/TD]
[TD="align: right"]$6,697[/TD]
[TD="align: right"]107%[/TD]
[TD="align: right"]$376[/TD]
[TD="align: right"]102%[/TD]
[TD="align: right"]$1,030[/TD]
[TD="align: right"]118%[/TD]
[TD="align: right"]$425[/TD]
[TD="align: right"]88%[/TD]
[TD="align: right"]$9,223[/TD]
[TD="align: right"]107%[/TD]
[/TR]
[TR]
[TD]10/15/2017[/TD]
[TD="align: right"]$551[/TD]
[TD="align: right"]102%[/TD]
[TD="align: right"]$41[/TD]
[TD="align: right"]256%[/TD]
[TD="align: right"]$198[/TD]
[TD="align: right"]143%[/TD]
[TD="align: right"]$6,865[/TD]
[TD="align: right"]103%[/TD]
[TD="align: right"]$379[/TD]
[TD="align: right"]101%[/TD]
[TD="align: right"]$1,889[/TD]
[TD="align: right"]183%[/TD]
[TD="align: right"]$723[/TD]
[TD="align: right"]170%[/TD]
[TD="align: right"]$10,644[/TD]
[TD="align: right"]115%[/TD]
[/TR]
[TR]
[TD]10/22/2017[/TD]
[TD="align: right"]$572[/TD]
[TD="align: right"]104%[/TD]
[TD="align: right"]$69[/TD]
[TD="align: right"]168%[/TD]
[TD="align: right"]$180[/TD]
[TD="align: right"]91%[/TD]
[TD="align: right"]$7,000[/TD]
[TD="align: right"]102%[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$5,400[/TD]
[TD="align: right"]286%[/TD]
[TD="align: right"]$1,500[/TD]
[TD="align: right"]207%[/TD]
[TD="align: right"]$14,721[/TD]
[TD="align: right"]138%[/TD]
[/TR]
[TR]
[TD]10/29/2017[/TD]
[TD="align: right"]$473[/TD]
[TD="align: right"]83%[/TD]
[TD="align: right"]$23[/TD]
[TD="align: right"]33%[/TD]
[TD="align: right"]$461[/TD]
[TD="align: right"]256%[/TD]
[TD="align: right"]$7,110[/TD]
[TD="align: right"]102%[/TD]
[TD="align: right"]$527[/TD]
[TD][/TD]
[TD="align: right"]$0[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]$8,999[/TD]
[TD="align: right"]600%[/TD]
[TD="align: right"]$17,593[/TD]
[TD="align: right"]120%[/TD]
[/TR]
[TR]
[TD]Grand Total[/TD]
[TD="align: right"]$13,723[/TD]
[TD][/TD]
[TD="align: right"]$1,868[/TD]
[TD][/TD]
[TD="align: right"]$11,041[/TD]
[TD][/TD]
[TD="align: right"]$183,343[/TD]
[TD][/TD]
[TD="align: right"]$4,259[/TD]
[TD][/TD]
[TD="align: right"]$13,783[/TD]
[TD][/TD]
[TD="align: right"]$13,979[/TD]
[TD][/TD]
[TD="align: right"]$241,996[/TD]
[TD][TABLE="width: 1066"]
<tbody>[TR]
[TD]6/11/2017[/TD]
[TD="align: right"]$0[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]$30[/TD]
[TD="align: right"]50%[/TD]
[TD="align: right"]$105[/TD]
[TD="align: right"]45%[/TD]
[TD="align: right"]$4,802[/TD]
[TD="align: right"]154%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$4,937[/TD]
[TD="align: right"]133%[/TD]
[/TR]
[TR]
[TD]6/18/2017[/TD]
[TD="align: right"]$248[/TD]
[TD][/TD]
[TD="align: right"]$7[/TD]
[TD="align: right"]23%[/TD]
[TD="align: right"]$549[/TD]
[TD="align: right"]524%[/TD]
[TD="align: right"]$5,534[/TD]
[TD="align: right"]115%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$6,339[/TD]
[TD="align: right"]128%[/TD]
[/TR]
[TR]
[TD]6/25/2017[/TD]
[TD="align: right"]$217[/TD]
[TD="align: right"]87%[/TD]
[TD="align: right"]$30[/TD]
[TD="align: right"]429%[/TD]
[TD="align: right"]$323[/TD]
[TD="align: right"]59%[/TD]
[TD="align: right"]$7,458[/TD]
[TD="align: right"]135%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$8,028[/TD]
[TD="align: right"]127%[/TD]
[/TR]
[TR]
[TD]7/2/2017[/TD]
[TD="align: right"]$220[/TD]
[TD="align: right"]101%[/TD]
[TD="align: right"]$45[/TD]
[TD="align: right"]150%[/TD]
[TD="align: right"]$371[/TD]
[TD="align: right"]115%[/TD]
[TD="align: right"]$8,658[/TD]
[TD="align: right"]116%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$9,294[/TD]
[TD="align: right"]116%[/TD]
[/TR]
[TR]
[TD]7/9/2017[/TD]
[TD="align: right"]$0[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]$0[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]$328[/TD]
[TD="align: right"]88%[/TD]
[TD="align: right"]$7,062[/TD]
[TD="align: right"]82%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$7,390[/TD]
[TD="align: right"]80%[/TD]
[/TR]
[TR]
[TD]7/16/2017[/TD]
[TD="align: right"]$315[/TD]
[TD][/TD]
[TD="align: right"]$60[/TD]
[TD][/TD]
[TD="align: right"]$621[/TD]
[TD="align: right"]189%[/TD]
[TD="align: right"]$6,903[/TD]
[TD="align: right"]98%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$7,899[/TD]
[TD="align: right"]107%[/TD]
[/TR]
[TR]
[TD]7/23/2017[/TD]
[TD="align: right"]$396[/TD]
[TD="align: right"]126%[/TD]
[TD="align: right"]$45[/TD]
[TD="align: right"]75%[/TD]
[TD="align: right"]$554[/TD]
[TD="align: right"]89%[/TD]
[TD="align: right"]$7,471[/TD]
[TD="align: right"]108%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$8,465[/TD]
[TD="align: right"]107%[/TD]
[/TR]
[TR]
[TD]7/30/2017[/TD]
[TD="align: right"]$418[/TD]
[TD="align: right"]106%[/TD]
[TD="align: right"]$45[/TD]
[TD="align: right"]100%[/TD]
[TD="align: right"]$784[/TD]
[TD="align: right"]142%[/TD]
[TD="align: right"]$10,898[/TD]
[TD="align: right"]146%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$12,146[/TD]
[TD="align: right"]143%[/TD]
[/TR]
[TR]
[TD]8/6/2017[/TD]
[TD="align: right"]$438[/TD]
[TD="align: right"]105%[/TD]
[TD="align: right"]$29[/TD]
[TD="align: right"]64%[/TD]
[TD="align: right"]$444[/TD]
[TD="align: right"]57%[/TD]
[TD="align: right"]$5,629[/TD]
[TD="align: right"]52%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$6,540[/TD]
[TD="align: right"]54%[/TD]
[/TR]
[TR]
[TD]8/13/2017[/TD]
[TD="align: right"]$473[/TD]
[TD="align: right"]108%[/TD]
[TD="align: right"]$23[/TD]
[TD="align: right"]79%[/TD]
[TD="align: right"]$461[/TD]
[TD="align: right"]104%[/TD]
[TD="align: right"]$7,110[/TD]
[TD="align: right"]126%[/TD]
[TD="align: right"]$527[/TD]
[TD][/TD]
[TD="align: right"]$0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$8,594[/TD]
[TD="align: right"]131%[/TD]
[/TR]
[TR]
[TD]8/20/2017[/TD]
[TD="align: right"]$482[/TD]
[TD="align: right"]102%[/TD]
[TD="align: right"]$30[/TD]
[TD="align: right"]130%[/TD]
[TD="align: right"]$237[/TD]
[TD="align: right"]51%[/TD]
[TD="align: right"]$5,787[/TD]
[TD="align: right"]81%[/TD]
[TD="align: right"]$450[/TD]
[TD="align: right"]85%[/TD]
[TD="align: right"]$749[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$7,735[/TD]
[TD="align: right"]90%[/TD]
[/TR]
[TR]
[TD]8/27/2017[/TD]
[TD="align: right"]$416[/TD]
[TD="align: right"]86%[/TD]
[TD="align: right"]$45[/TD]
[TD="align: right"]150%[/TD]
[TD="align: right"]$384[/TD]
[TD="align: right"]162%[/TD]
[TD="align: right"]$8,120[/TD]
[TD="align: right"]140%[/TD]
[TD="align: right"]$338[/TD]
[TD="align: right"]75%[/TD]
[TD="align: right"]$729[/TD]
[TD="align: right"]97%[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$10,032[/TD]
[TD="align: right"]130%[/TD]
[/TR]
[TR]
[TD]9/3/2017[/TD]
[TD="align: right"]$495[/TD]
[TD="align: right"]119%[/TD]
[TD="align: right"]$128[/TD]
[TD="align: right"]284%[/TD]
[TD="align: right"]$177[/TD]
[TD="align: right"]46%[/TD]
[TD="align: right"]$8,241[/TD]
[TD="align: right"]101%[/TD]
[TD="align: right"]$307[/TD]
[TD="align: right"]91%[/TD]
[TD="align: right"]$691[/TD]
[TD="align: right"]95%[/TD]
[TD="align: right"]$436[/TD]
[TD][/TD]
[TD="align: right"]$10,475[/TD]
[TD="align: right"]104%[/TD]
[/TR]
[TR]
[TD]9/10/2017[/TD]
[TD="align: right"]$322[/TD]
[TD="align: right"]65%[/TD]
[TD="align: right"]$45[/TD]
[TD="align: right"]35%[/TD]
[TD="align: right"]$357[/TD]
[TD="align: right"]201%[/TD]
[TD="align: right"]$6,656[/TD]
[TD="align: right"]81%[/TD]
[TD="align: right"]$312[/TD]
[TD="align: right"]102%[/TD]
[TD="align: right"]$793[/TD]
[TD="align: right"]115%[/TD]
[TD="align: right"]$488[/TD]
[TD="align: right"]112%[/TD]
[TD="align: right"]$8,973[/TD]
[TD="align: right"]86%[/TD]
[/TR]
[TR]
[TD]9/17/2017[/TD]
[TD="align: right"]$312[/TD]
[TD="align: right"]97%[/TD]
[TD="align: right"]$31[/TD]
[TD="align: right"]69%[/TD]
[TD="align: right"]$291[/TD]
[TD="align: right"]81%[/TD]
[TD="align: right"]$6,720[/TD]
[TD="align: right"]101%[/TD]
[TD="align: right"]$326[/TD]
[TD="align: right"]104%[/TD]
[TD="align: right"]$656[/TD]
[TD="align: right"]83%[/TD]
[TD="align: right"]$374[/TD]
[TD="align: right"]77%[/TD]
[TD="align: right"]$8,708[/TD]
[TD="align: right"]97%[/TD]
[/TR]
[TR]
[TD]9/24/2017[/TD]
[TD="align: right"]$392[/TD]
[TD="align: right"]125%[/TD]
[TD="align: right"]$63[/TD]
[TD="align: right"]203%[/TD]
[TD="align: right"]$185[/TD]
[TD="align: right"]64%[/TD]
[TD="align: right"]$8,252[/TD]
[TD="align: right"]123%[/TD]
[TD="align: right"]$351[/TD]
[TD="align: right"]108%[/TD]
[TD="align: right"]$973[/TD]
[TD="align: right"]148%[/TD]
[TD="align: right"]$551[/TD]
[TD="align: right"]148%[/TD]
[TD="align: right"]$10,767[/TD]
[TD="align: right"]124%[/TD]
[/TR]
[TR]
[TD]10/1/2017[/TD]
[TD="align: right"]$366[/TD]
[TD="align: right"]94%[/TD]
[TD="align: right"]$31[/TD]
[TD="align: right"]49%[/TD]
[TD="align: right"]$251[/TD]
[TD="align: right"]135%[/TD]
[TD="align: right"]$6,234[/TD]
[TD="align: right"]76%[/TD]
[TD="align: right"]$367[/TD]
[TD="align: right"]105%[/TD]
[TD="align: right"]$873[/TD]
[TD="align: right"]90%[/TD]
[TD="align: right"]$483[/TD]
[TD="align: right"]88%[/TD]
[TD="align: right"]$8,605[/TD]
[TD="align: right"]80%[/TD]
[/TR]
[TR]
[TD]10/8/2017[/TD]
[TD="align: right"]$540[/TD]
[TD="align: right"]147%[/TD]
[TD="align: right"]$16[/TD]
[TD="align: right"]52%[/TD]
[TD="align: right"]$138[/TD]
[TD="align: right"]55%[/TD]
[TD="align: right"]$6,697[/TD]
[TD="align: right"]107%[/TD]
[TD="align: right"]$376[/TD]
[TD="align: right"]102%[/TD]
[TD="align: right"]$1,030[/TD]
[TD="align: right"]118%[/TD]
[TD="align: right"]$425[/TD]
[TD="align: right"]88%[/TD]
[TD="align: right"]$9,223[/TD]
[TD="align: right"]107%[/TD]
[/TR]
[TR]
[TD]10/15/2017[/TD]
[TD="align: right"]$551[/TD]
[TD="align: right"]102%[/TD]
[TD="align: right"]$41[/TD]
[TD="align: right"]256%[/TD]
[TD="align: right"]$198[/TD]
[TD="align: right"]143%[/TD]
[TD="align: right"]$6,865[/TD]
[TD="align: right"]103%[/TD]
[TD="align: right"]$379[/TD]
[TD="align: right"]101%[/TD]
[TD="align: right"]$1,889[/TD]
[TD="align: right"]183%[/TD]
[TD="align: right"]$723[/TD]
[TD="align: right"]170%[/TD]
[TD="align: right"]$10,644[/TD]
[TD="align: right"]115%[/TD]
[/TR]
[TR]
[TD]10/22/2017[/TD]
[TD="align: right"]$572[/TD]
[TD="align: right"]104%[/TD]
[TD="align: right"]$69[/TD]
[TD="align: right"]168%[/TD]
[TD="align: right"]$180[/TD]
[TD="align: right"]91%[/TD]
[TD="align: right"]$7,000[/TD]
[TD="align: right"]102%[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$5,400[/TD]
[TD="align: right"]286%[/TD]
[TD="align: right"]$1,500[/TD]
[TD="align: right"]207%[/TD]
[TD="align: right"]$14,721[/TD]
[TD="align: right"]138%[/TD]
[/TR]
[TR]
[TD]10/29/2017[/TD]
[TD="align: right"]$473[/TD]
[TD="align: right"]83%[/TD]
[TD="align: right"]$23[/TD]
[TD="align: right"]33%[/TD]
[TD="align: right"]$461[/TD]
[TD="align: right"]256%[/TD]
[TD="align: right"]$7,110[/TD]
[TD="align: right"]102%[/TD]
[TD="align: right"]$527[/TD]
[TD][/TD]
[TD="align: right"]$0[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]$8,999[/TD]
[TD="align: right"]600%[/TD]
[TD="align: right"]$17,593[/TD]
[TD="align: right"]120%[/TD]
[/TR]
[TR]
[TD]Grand Total[/TD]
[TD="align: right"]$13,723[/TD]
[TD][/TD]
[TD="align: right"]$1,868[/TD]
[TD][/TD]
[TD="align: right"]$11,041[/TD]
[TD][/TD]
[TD="align: right"]$183,343[/TD]
[TD][/TD]
[TD="align: right"]$4,259[/TD]
[TD][/TD]
[TD="align: right"]$13,783[/TD]
[TD][/TD]
[TD="align: right"]$13,979[/TD]
[TD][/TD]
[TD="align: right"]$241,996[/TD]
[TD][TABLE="width: 1066"]
<tbody>[TR]
[TD]6/11/2017[/TD]
[TD="align: right"]$0[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]$30[/TD]
[TD="align: right"]50%[/TD]
[TD="align: right"]$105[/TD]
[TD="align: right"]45%[/TD]
[TD="align: right"]$4,802[/TD]
[TD="align: right"]154%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$4,937[/TD]
[TD="align: right"]133%[/TD]
[/TR]
[TR]
[TD]6/18/2017[/TD]
[TD="align: right"]$248[/TD]
[TD][/TD]
[TD="align: right"]$7[/TD]
[TD="align: right"]23%[/TD]
[TD="align: right"]$549[/TD]
[TD="align: right"]524%[/TD]
[TD="align: right"]$5,534[/TD]
[TD="align: right"]115%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$6,339[/TD]
[TD="align: right"]128%[/TD]
[/TR]
[TR]
[TD]6/25/2017[/TD]
[TD="align: right"]$217[/TD]
[TD="align: right"]87%[/TD]
[TD="align: right"]$30[/TD]
[TD="align: right"]429%[/TD]
[TD="align: right"]$323[/TD]
[TD="align: right"]59%[/TD]
[TD="align: right"]$7,458[/TD]
[TD="align: right"]135%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$8,028[/TD]
[TD="align: right"]127%[/TD]
[/TR]
[TR]
[TD]7/2/2017[/TD]
[TD="align: right"]$220[/TD]
[TD="align: right"]101%[/TD]
[TD="align: right"]$45[/TD]
[TD="align: right"]150%[/TD]
[TD="align: right"]$371[/TD]
[TD="align: right"]115%[/TD]
[TD="align: right"]$8,658[/TD]
[TD="align: right"]116%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$9,294[/TD]
[TD="align: right"]116%[/TD]
[/TR]
[TR]
[TD]7/9/2017[/TD]
[TD="align: right"]$0[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]$0[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]$328[/TD]
[TD="align: right"]88%[/TD]
[TD="align: right"]$7,062[/TD]
[TD="align: right"]82%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$7,390[/TD]
[TD="align: right"]80%[/TD]
[/TR]
[TR]
[TD]7/16/2017[/TD]
[TD="align: right"]$315[/TD]
[TD][/TD]
[TD="align: right"]$60[/TD]
[TD][/TD]
[TD="align: right"]$621[/TD]
[TD="align: right"]189%[/TD]
[TD="align: right"]$6,903[/TD]
[TD="align: right"]98%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$7,899[/TD]
[TD="align: right"]107%[/TD]
[/TR]
[TR]
[TD]7/23/2017[/TD]
[TD="align: right"]$396[/TD]
[TD="align: right"]126%[/TD]
[TD="align: right"]$45[/TD]
[TD="align: right"]75%[/TD]
[TD="align: right"]$554[/TD]
[TD="align: right"]89%[/TD]
[TD="align: right"]$7,471[/TD]
[TD="align: right"]108%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$8,465[/TD]
[TD="align: right"]107%[/TD]
[/TR]
[TR]
[TD]7/30/2017[/TD]
[TD="align: right"]$418[/TD]
[TD="align: right"]106%[/TD]
[TD="align: right"]$45[/TD]
[TD="align: right"]100%[/TD]
[TD="align: right"]$784[/TD]
[TD="align: right"]142%[/TD]
[TD="align: right"]$10,898[/TD]
[TD="align: right"]146%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$12,146[/TD]
[TD="align: right"]143%[/TD]
[/TR]
[TR]
[TD]8/6/2017[/TD]
[TD="align: right"]$438[/TD]
[TD="align: right"]105%[/TD]
[TD="align: right"]$29[/TD]
[TD="align: right"]64%[/TD]
[TD="align: right"]$444[/TD]
[TD="align: right"]57%[/TD]
[TD="align: right"]$5,629[/TD]
[TD="align: right"]52%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$6,540[/TD]
[TD="align: right"]54%[/TD]
[/TR]
[TR]
[TD]8/13/2017[/TD]
[TD="align: right"]$473[/TD]
[TD="align: right"]108%[/TD]
[TD="align: right"]$23[/TD]
[TD="align: right"]79%[/TD]
[TD="align: right"]$461[/TD]
[TD="align: right"]104%[/TD]
[TD="align: right"]$7,110[/TD]
[TD="align: right"]126%[/TD]
[TD="align: right"]$527[/TD]
[TD][/TD]
[TD="align: right"]$0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$8,594[/TD]
[TD="align: right"]131%[/TD]
[/TR]
[TR]
[TD]8/20/2017[/TD]
[TD="align: right"]$482[/TD]
[TD="align: right"]102%[/TD]
[TD="align: right"]$30[/TD]
[TD="align: right"]130%[/TD]
[TD="align: right"]$237[/TD]
[TD="align: right"]51%[/TD]
[TD="align: right"]$5,787[/TD]
[TD="align: right"]81%[/TD]
[TD="align: right"]$450[/TD]
[TD="align: right"]85%[/TD]
[TD="align: right"]$749[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$7,735[/TD]
[TD="align: right"]90%[/TD]
[/TR]
[TR]
[TD]8/27/2017[/TD]
[TD="align: right"]$416[/TD]
[TD="align: right"]86%[/TD]
[TD="align: right"]$45[/TD]
[TD="align: right"]150%[/TD]
[TD="align: right"]$384[/TD]
[TD="align: right"]162%[/TD]
[TD="align: right"]$8,120[/TD]
[TD="align: right"]140%[/TD]
[TD="align: right"]$338[/TD]
[TD="align: right"]75%[/TD]
[TD="align: right"]$729[/TD]
[TD="align: right"]97%[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$10,032[/TD]
[TD="align: right"]130%[/TD]
[/TR]
[TR]
[TD]9/3/2017[/TD]
[TD="align: right"]$495[/TD]
[TD="align: right"]119%[/TD]
[TD="align: right"]$128[/TD]
[TD="align: right"]284%[/TD]
[TD="align: right"]$177[/TD]
[TD="align: right"]46%[/TD]
[TD="align: right"]$8,241[/TD]
[TD="align: right"]101%[/TD]
[TD="align: right"]$307[/TD]
[TD="align: right"]91%[/TD]
[TD="align: right"]$691[/TD]
[TD="align: right"]95%[/TD]
[TD="align: right"]$436[/TD]
[TD][/TD]
[TD="align: right"]$10,475[/TD]
[TD="align: right"]104%[/TD]
[/TR]
[TR]
[TD]9/10/2017[/TD]
[TD="align: right"]$322[/TD]
[TD="align: right"]65%[/TD]
[TD="align: right"]$45[/TD]
[TD="align: right"]35%[/TD]
[TD="align: right"]$357[/TD]
[TD="align: right"]201%[/TD]
[TD="align: right"]$6,656[/TD]
[TD="align: right"]81%[/TD]
[TD="align: right"]$312[/TD]
[TD="align: right"]102%[/TD]
[TD="align: right"]$793[/TD]
[TD="align: right"]115%[/TD]
[TD="align: right"]$488[/TD]
[TD="align: right"]112%[/TD]
[TD="align: right"]$8,973[/TD]
[TD="align: right"]86%[/TD]
[/TR]
[TR]
[TD]9/17/2017[/TD]
[TD="align: right"]$312[/TD]
[TD="align: right"]97%[/TD]
[TD="align: right"]$31[/TD]
[TD="align: right"]69%[/TD]
[TD="align: right"]$291[/TD]
[TD="align: right"]81%[/TD]
[TD="align: right"]$6,720[/TD]
[TD="align: right"]101%[/TD]
[TD="align: right"]$326[/TD]
[TD="align: right"]104%[/TD]
[TD="align: right"]$656[/TD]
[TD="align: right"]83%[/TD]
[TD="align: right"]$374[/TD]
[TD="align: right"]77%[/TD]
[TD="align: right"]$8,708[/TD]
[TD="align: right"]97%[/TD]
[/TR]
[TR]
[TD]9/24/2017[/TD]
[TD="align: right"]$392[/TD]
[TD="align: right"]125%[/TD]
[TD="align: right"]$63[/TD]
[TD="align: right"]203%[/TD]
[TD="align: right"]$185[/TD]
[TD="align: right"]64%[/TD]
[TD="align: right"]$8,252[/TD]
[TD="align: right"]123%[/TD]
[TD="align: right"]$351[/TD]
[TD="align: right"]108%[/TD]
[TD="align: right"]$973[/TD]
[TD="align: right"]148%[/TD]
[TD="align: right"]$551[/TD]
[TD="align: right"]148%[/TD]
[TD="align: right"]$10,767[/TD]
[TD="align: right"]124%[/TD]
[/TR]
[TR]
[TD]10/1/2017[/TD]
[TD="align: right"]$366[/TD]
[TD="align: right"]94%[/TD]
[TD="align: right"]$31[/TD]
[TD="align: right"]49%[/TD]
[TD="align: right"]$251[/TD]
[TD="align: right"]135%[/TD]
[TD="align: right"]$6,234[/TD]
[TD="align: right"]76%[/TD]
[TD="align: right"]$367[/TD]
[TD="align: right"]105%[/TD]
[TD="align: right"]$873[/TD]
[TD="align: right"]90%[/TD]
[TD="align: right"]$483[/TD]
[TD="align: right"]88%[/TD]
[TD="align: right"]$8,605[/TD]
[TD="align: right"]80%[/TD]
[/TR]
[TR]
[TD]10/8/2017[/TD]
[TD="align: right"]$540[/TD]
[TD="align: right"]147%[/TD]
[TD="align: right"]$16[/TD]
[TD="align: right"]52%[/TD]
[TD="align: right"]$138[/TD]
[TD="align: right"]55%[/TD]
[TD="align: right"]$6,697[/TD]
[TD="align: right"]107%[/TD]
[TD="align: right"]$376[/TD]
[TD="align: right"]102%[/TD]
[TD="align: right"]$1,030[/TD]
[TD="align: right"]118%[/TD]
[TD="align: right"]$425[/TD]
[TD="align: right"]88%[/TD]
[TD="align: right"]$9,223[/TD]
[TD="align: right"]107%[/TD]
[/TR]
[TR]
[TD]10/15/2017[/TD]
[TD="align: right"]$551[/TD]
[TD="align: right"]102%[/TD]
[TD="align: right"]$41[/TD]
[TD="align: right"]256%[/TD]
[TD="align: right"]$198[/TD]
[TD="align: right"]143%[/TD]
[TD="align: right"]$6,865[/TD]
[TD="align: right"]103%[/TD]
[TD="align: right"]$379[/TD]
[TD="align: right"]101%[/TD]
[TD="align: right"]$1,889[/TD]
[TD="align: right"]183%[/TD]
[TD="align: right"]$723[/TD]
[TD="align: right"]170%[/TD]
[TD="align: right"]$10,644[/TD]
[TD="align: right"]115%[/TD]
[/TR]
[TR]
[TD]10/22/2017[/TD]
[TD="align: right"]$572[/TD]
[TD="align: right"]104%[/TD]
[TD="align: right"]$69[/TD]
[TD="align: right"]168%[/TD]
[TD="align: right"]$180[/TD]
[TD="align: right"]91%[/TD]
[TD="align: right"]$7,000[/TD]
[TD="align: right"]102%[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$5,400[/TD]
[TD="align: right"]286%[/TD]
[TD="align: right"]$1,500[/TD]
[TD="align: right"]207%[/TD]
[TD="align: right"]$14,721[/TD]
[TD="align: right"]138%[/TD]
[/TR]
[TR]
[TD]10/29/2017[/TD]
[TD="align: right"]$473[/TD]
[TD="align: right"]83%[/TD]
[TD="align: right"]$23[/TD]
[TD="align: right"]33%[/TD]
[TD="align: right"]$461[/TD]
[TD="align: right"]256%[/TD]
[TD="align: right"]$7,110[/TD]
[TD="align: right"]102%[/TD]
[TD="align: right"]$527[/TD]
[TD][/TD]
[TD="align: right"]$0[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]$8,999[/TD]
[TD="align: right"]600%[/TD]
[TD="align: right"]$17,593[/TD]
[TD="align: right"]120%[/TD]
[/TR]
[TR]
[TD]Grand Total[/TD]
[TD="align: right"]$13,723[/TD]
[TD][/TD]
[TD="align: right"]$1,868[/TD]
[TD][/TD]
[TD="align: right"]$11,041[/TD]
[TD][/TD]
[TD="align: right"]$183,343[/TD]
[TD][/TD]
[TD="align: right"]$4,259[/TD]
[TD][/TD]
[TD="align: right"]$13,783[/TD]
[TD][/TD]
[TD="align: right"]$13,979[/TD]
[TD][/TD]
[TD="align: right"]$241,996[/TD]
[TD][TABLE="width: 1066"]
<tbody>[TR]
[TD]6/11/2017[/TD]
[TD="align: right"]$0[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]$30[/TD]
[TD="align: right"]50%[/TD]
[TD="align: right"]$105[/TD]
[TD="align: right"]45%[/TD]
[TD="align: right"]$4,802[/TD]
[TD="align: right"]154%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$4,937[/TD]
[TD="align: right"]133%[/TD]
[/TR]
[TR]
[TD]6/18/2017[/TD]
[TD="align: right"]$248[/TD]
[TD][/TD]
[TD="align: right"]$7[/TD]
[TD="align: right"]23%[/TD]
[TD="align: right"]$549[/TD]
[TD="align: right"]524%[/TD]
[TD="align: right"]$5,534[/TD]
[TD="align: right"]115%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$6,339[/TD]
[TD="align: right"]128%[/TD]
[/TR]
[TR]
[TD]6/25/2017[/TD]
[TD="align: right"]$217[/TD]
[TD="align: right"]87%[/TD]
[TD="align: right"]$30[/TD]
[TD="align: right"]429%[/TD]
[TD="align: right"]$323[/TD]
[TD="align: right"]59%[/TD]
[TD="align: right"]$7,458[/TD]
[TD="align: right"]135%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$8,028[/TD]
[TD="align: right"]127%[/TD]
[/TR]
[TR]
[TD]7/2/2017[/TD]
[TD="align: right"]$220[/TD]
[TD="align: right"]101%[/TD]
[TD="align: right"]$45[/TD]
[TD="align: right"]150%[/TD]
[TD="align: right"]$371[/TD]
[TD="align: right"]115%[/TD]
[TD="align: right"]$8,658[/TD]
[TD="align: right"]116%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$9,294[/TD]
[TD="align: right"]116%[/TD]
[/TR]
[TR]
[TD]7/9/2017[/TD]
[TD="align: right"]$0[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]$0[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]$328[/TD]
[TD="align: right"]88%[/TD]
[TD="align: right"]$7,062[/TD]
[TD="align: right"]82%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$7,390[/TD]
[TD="align: right"]80%[/TD]
[/TR]
[TR]
[TD]7/16/2017[/TD]
[TD="align: right"]$315[/TD]
[TD][/TD]
[TD="align: right"]$60[/TD]
[TD][/TD]
[TD="align: right"]$621[/TD]
[TD="align: right"]189%[/TD]
[TD="align: right"]$6,903[/TD]
[TD="align: right"]98%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$7,899[/TD]
[TD="align: right"]107%[/TD]
[/TR]
[TR]
[TD]7/23/2017[/TD]
[TD="align: right"]$396[/TD]
[TD="align: right"]126%[/TD]
[TD="align: right"]$45[/TD]
[TD="align: right"]75%[/TD]
[TD="align: right"]$554[/TD]
[TD="align: right"]89%[/TD]
[TD="align: right"]$7,471[/TD]
[TD="align: right"]108%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$8,465[/TD]
[TD="align: right"]107%[/TD]
[/TR]
[TR]
[TD]7/30/2017[/TD]
[TD="align: right"]$418[/TD]
[TD="align: right"]106%[/TD]
[TD="align: right"]$45[/TD]
[TD="align: right"]100%[/TD]
[TD="align: right"]$784[/TD]
[TD="align: right"]142%[/TD]
[TD="align: right"]$10,898[/TD]
[TD="align: right"]146%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$12,146[/TD]
[TD="align: right"]143%[/TD]
[/TR]
[TR]
[TD]8/6/2017[/TD]
[TD="align: right"]$438[/TD]
[TD="align: right"]105%[/TD]
[TD="align: right"]$29[/TD]
[TD="align: right"]64%[/TD]
[TD="align: right"]$444[/TD]
[TD="align: right"]57%[/TD]
[TD="align: right"]$5,629[/TD]
[TD="align: right"]52%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$6,540[/TD]
[TD="align: right"]54%[/TD]
[/TR]
[TR]
[TD]8/13/2017[/TD]
[TD="align: right"]$473[/TD]
[TD="align: right"]108%[/TD]
[TD="align: right"]$23[/TD]
[TD="align: right"]79%[/TD]
[TD="align: right"]$461[/TD]
[TD="align: right"]104%[/TD]
[TD="align: right"]$7,110[/TD]
[TD="align: right"]126%[/TD]
[TD="align: right"]$527[/TD]
[TD][/TD]
[TD="align: right"]$0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$8,594[/TD]
[TD="align: right"]131%[/TD]
[/TR]
[TR]
[TD]8/20/2017[/TD]
[TD="align: right"]$482[/TD]
[TD="align: right"]102%[/TD]
[TD="align: right"]$30[/TD]
[TD="align: right"]130%[/TD]
[TD="align: right"]$237[/TD]
[TD="align: right"]51%[/TD]
[TD="align: right"]$5,787[/TD]
[TD="align: right"]81%[/TD]
[TD="align: right"]$450[/TD]
[TD="align: right"]85%[/TD]
[TD="align: right"]$749[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$7,735[/TD]
[TD="align: right"]90%[/TD]
[/TR]
[TR]
[TD]8/27/2017[/TD]
[TD="align: right"]$416[/TD]
[TD="align: right"]86%[/TD]
[TD="align: right"]$45[/TD]
[TD="align: right"]150%[/TD]
[TD="align: right"]$384[/TD]
[TD="align: right"]162%[/TD]
[TD="align: right"]$8,120[/TD]
[TD="align: right"]140%[/TD]
[TD="align: right"]$338[/TD]
[TD="align: right"]75%[/TD]
[TD="align: right"]$729[/TD]
[TD="align: right"]97%[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$10,032[/TD]
[TD="align: right"]130%[/TD]
[/TR]
[TR]
[TD]9/3/2017[/TD]
[TD="align: right"]$495[/TD]
[TD="align: right"]119%[/TD]
[TD="align: right"]$128[/TD]
[TD="align: right"]284%[/TD]
[TD="align: right"]$177[/TD]
[TD="align: right"]46%[/TD]
[TD="align: right"]$8,241[/TD]
[TD="align: right"]101%[/TD]
[TD="align: right"]$307[/TD]
[TD="align: right"]91%[/TD]
[TD="align: right"]$691[/TD]
[TD="align: right"]95%[/TD]
[TD="align: right"]$436[/TD]
[TD][/TD]
[TD="align: right"]$10,475[/TD]
[TD="align: right"]104%[/TD]
[/TR]
[TR]
[TD]9/10/2017[/TD]
[TD="align: right"]$322[/TD]
[TD="align: right"]65%[/TD]
[TD="align: right"]$45[/TD]
[TD="align: right"]35%[/TD]
[TD="align: right"]$357[/TD]
[TD="align: right"]201%[/TD]
[TD="align: right"]$6,656[/TD]
[TD="align: right"]81%[/TD]
[TD="align: right"]$312[/TD]
[TD="align: right"]102%[/TD]
[TD="align: right"]$793[/TD]
[TD="align: right"]115%[/TD]
[TD="align: right"]$488[/TD]
[TD="align: right"]112%[/TD]
[TD="align: right"]$8,973[/TD]
[TD="align: right"]86%[/TD]
[/TR]
[TR]
[TD]9/17/2017[/TD]
[TD="align: right"]$312[/TD]
[TD="align: right"]97%[/TD]
[TD="align: right"]$31[/TD]
[TD="align: right"]69%[/TD]
[TD="align: right"]$291[/TD]
[TD="align: right"]81%[/TD]
[TD="align: right"]$6,720[/TD]
[TD="align: right"]101%[/TD]
[TD="align: right"]$326[/TD]
[TD="align: right"]104%[/TD]
[TD="align: right"]$656[/TD]
[TD="align: right"]83%[/TD]
[TD="align: right"]$374[/TD]
[TD="align: right"]77%[/TD]
[TD="align: right"]$8,708[/TD]
[TD="align: right"]97%[/TD]
[/TR]
[TR]
[TD]9/24/2017[/TD]
[TD="align: right"]$392[/TD]
[TD="align: right"]125%[/TD]
[TD="align: right"]$63[/TD]
[TD="align: right"]203%[/TD]
[TD="align: right"]$185[/TD]
[TD="align: right"]64%[/TD]
[TD="align: right"]$8,252[/TD]
[TD="align: right"]123%[/TD]
[TD="align: right"]$351[/TD]
[TD="align: right"]108%[/TD]
[TD="align: right"]$973[/TD]
[TD="align: right"]148%[/TD]
[TD="align: right"]$551[/TD]
[TD="align: right"]148%[/TD]
[TD="align: right"]$10,767[/TD]
[TD="align: right"]124%[/TD]
[/TR]
[TR]
[TD]10/1/2017[/TD]
[TD="align: right"]$366[/TD]
[TD="align: right"]94%[/TD]
[TD="align: right"]$31[/TD]
[TD="align: right"]49%[/TD]
[TD="align: right"]$251[/TD]
[TD="align: right"]135%[/TD]
[TD="align: right"]$6,234[/TD]
[TD="align: right"]76%[/TD]
[TD="align: right"]$367[/TD]
[TD="align: right"]105%[/TD]
[TD="align: right"]$873[/TD]
[TD="align: right"]90%[/TD]
[TD="align: right"]$483[/TD]
[TD="align: right"]88%[/TD]
[TD="align: right"]$8,605[/TD]
[TD="align: right"]80%[/TD]
[/TR]
[TR]
[TD]10/8/2017[/TD]
[TD="align: right"]$540[/TD]
[TD="align: right"]147%[/TD]
[TD="align: right"]$16[/TD]
[TD="align: right"]52%[/TD]
[TD="align: right"]$138[/TD]
[TD="align: right"]55%[/TD]
[TD="align: right"]$6,697[/TD]
[TD="align: right"]107%[/TD]
[TD="align: right"]$376[/TD]
[TD="align: right"]102%[/TD]
[TD="align: right"]$1,030[/TD]
[TD="align: right"]118%[/TD]
[TD="align: right"]$425[/TD]
[TD="align: right"]88%[/TD]
[TD="align: right"]$9,223[/TD]
[TD="align: right"]107%[/TD]
[/TR]
[TR]
[TD]10/15/2017[/TD]
[TD="align: right"]$551[/TD]
[TD="align: right"]102%[/TD]
[TD="align: right"]$41[/TD]
[TD="align: right"]256%[/TD]
[TD="align: right"]$198[/TD]
[TD="align: right"]143%[/TD]
[TD="align: right"]$6,865[/TD]
[TD="align: right"]103%[/TD]
[TD="align: right"]$379[/TD]
[TD="align: right"]101%[/TD]
[TD="align: right"]$1,889[/TD]
[TD="align: right"]183%[/TD]
[TD="align: right"]$723[/TD]
[TD="align: right"]170%[/TD]
[TD="align: right"]$10,644[/TD]
[TD="align: right"]115%[/TD]
[/TR]
[TR]
[TD]10/22/2017[/TD]
[TD="align: right"]$572[/TD]
[TD="align: right"]104%[/TD]
[TD="align: right"]$69[/TD]
[TD="align: right"]168%[/TD]
[TD="align: right"]$180[/TD]
[TD="align: right"]91%[/TD]
[TD="align: right"]$7,000[/TD]
[TD="align: right"]102%[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$5,400[/TD]
[TD="align: right"]286%[/TD]
[TD="align: right"]$1,500[/TD]
[TD="align: right"]207%[/TD]
[TD="align: right"]$14,721[/TD]
[TD="align: right"]138%[/TD]
[/TR]
[TR]
[TD]10/29/2017[/TD]
[TD="align: right"]$473[/TD]
[TD="align: right"]83%[/TD]
[TD="align: right"]$23[/TD]
[TD="align: right"]33%[/TD]
[TD="align: right"]$461[/TD]
[TD="align: right"]256%[/TD]
[TD="align: right"]$7,110[/TD]
[TD="align: right"]102%[/TD]
[TD="align: right"]$527[/TD]
[TD][/TD]
[TD="align: right"]$0[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]$8,999[/TD]
[TD="align: right"]600%[/TD]
[TD="align: right"]$17,593[/TD]
[TD="align: right"]120%[/TD]
[/TR]
[TR]
[TD]Grand Total[/TD]
[TD="align: right"]$13,723[/TD]
[TD][/TD]
[TD="align: right"]$1,868[/TD]
[TD][/TD]
[TD="align: right"]$11,041[/TD]
[TD][/TD]
[TD="align: right"]$183,343[/TD]
[TD][/TD]
[TD="align: right"]$4,259[/TD]
[TD][/TD]
[TD="align: right"]$13,783[/TD]
[TD][/TD]
[TD="align: right"]$13,979[/TD]
[TD][/TD]
[TD="align: right"]$241,996[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
Hi Jim,

Thank yo so much for the reply. Please see the below data. I want to color the empty cells yellow.



[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 1066"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]6/11/2017[/TD]
[TD="align: right"]$0[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]$30[/TD]
[TD="align: right"]50%[/TD]
[TD="align: right"]$105[/TD]
[TD="align: right"]45%[/TD]
[TD="align: right"]$4,802[/TD]
[TD="align: right"]154%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$4,937[/TD]
[TD="align: right"]133%[/TD]
[/TR]
[TR]
[TD]6/18/2017[/TD]
[TD="align: right"]$248[/TD]
[TD][/TD]
[TD="align: right"]$7[/TD]
[TD="align: right"]23%[/TD]
[TD="align: right"]$549[/TD]
[TD="align: right"]524%[/TD]
[TD="align: right"]$5,534[/TD]
[TD="align: right"]115%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$6,339[/TD]
[TD="align: right"]128%[/TD]
[/TR]
[TR]
[TD]6/25/2017[/TD]
[TD="align: right"]$217[/TD]
[TD="align: right"]87%[/TD]
[TD="align: right"]$30[/TD]
[TD="align: right"]429%[/TD]
[TD="align: right"]$323[/TD]
[TD="align: right"]59%[/TD]
[TD="align: right"]$7,458[/TD]
[TD="align: right"]135%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$8,028[/TD]
[TD="align: right"]127%[/TD]
[/TR]
[TR]
[TD]7/2/2017[/TD]
[TD="align: right"]$220[/TD]
[TD="align: right"]101%[/TD]
[TD="align: right"]$45[/TD]
[TD="align: right"]150%[/TD]
[TD="align: right"]$371[/TD]
[TD="align: right"]115%[/TD]
[TD="align: right"]$8,658[/TD]
[TD="align: right"]116%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$9,294[/TD]
[TD="align: right"]116%[/TD]
[/TR]
[TR]
[TD]7/9/2017[/TD]
[TD="align: right"]$0[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]$0[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]$328[/TD]
[TD="align: right"]88%[/TD]
[TD="align: right"]$7,062[/TD]
[TD="align: right"]82%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$7,390[/TD]
[TD="align: right"]80%[/TD]
[/TR]
[TR]
[TD]7/16/2017[/TD]
[TD="align: right"]$315[/TD]
[TD][/TD]
[TD="align: right"]$60[/TD]
[TD][/TD]
[TD="align: right"]$621[/TD]
[TD="align: right"]189%[/TD]
[TD="align: right"]$6,903[/TD]
[TD="align: right"]98%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$7,899[/TD]
[TD="align: right"]107%[/TD]
[/TR]
[TR]
[TD]7/23/2017[/TD]
[TD="align: right"]$396[/TD]
[TD="align: right"]126%[/TD]
[TD="align: right"]$45[/TD]
[TD="align: right"]75%[/TD]
[TD="align: right"]$554[/TD]
[TD="align: right"]89%[/TD]
[TD="align: right"]$7,471[/TD]
[TD="align: right"]108%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$8,465[/TD]
[TD="align: right"]107%[/TD]
[/TR]
[TR]
[TD]7/30/2017[/TD]
[TD="align: right"]$418[/TD]
[TD="align: right"]106%[/TD]
[TD="align: right"]$45[/TD]
[TD="align: right"]100%[/TD]
[TD="align: right"]$784[/TD]
[TD="align: right"]142%[/TD]
[TD="align: right"]$10,898[/TD]
[TD="align: right"]146%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$12,146[/TD]
[TD="align: right"]143%[/TD]
[/TR]
[TR]
[TD]8/6/2017[/TD]
[TD="align: right"]$438[/TD]
[TD="align: right"]105%[/TD]
[TD="align: right"]$29[/TD]
[TD="align: right"]64%[/TD]
[TD="align: right"]$444[/TD]
[TD="align: right"]57%[/TD]
[TD="align: right"]$5,629[/TD]
[TD="align: right"]52%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$6,540[/TD]
[TD="align: right"]54%[/TD]
[/TR]
[TR]
[TD]8/13/2017[/TD]
[TD="align: right"]$473[/TD]
[TD="align: right"]108%[/TD]
[TD="align: right"]$23[/TD]
[TD="align: right"]79%[/TD]
[TD="align: right"]$461[/TD]
[TD="align: right"]104%[/TD]
[TD="align: right"]$7,110[/TD]
[TD="align: right"]126%[/TD]
[TD="align: right"]$527[/TD]
[TD][/TD]
[TD="align: right"]$0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$8,594[/TD]
[TD="align: right"]131%[/TD]
[/TR]
[TR]
[TD]8/20/2017[/TD]
[TD="align: right"]$482[/TD]
[TD="align: right"]102%[/TD]
[TD="align: right"]$30[/TD]
[TD="align: right"]130%[/TD]
[TD="align: right"]$237[/TD]
[TD="align: right"]51%[/TD]
[TD="align: right"]$5,787[/TD]
[TD="align: right"]81%[/TD]
[TD="align: right"]$450[/TD]
[TD="align: right"]85%[/TD]
[TD="align: right"]$749[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$7,735[/TD]
[TD="align: right"]90%[/TD]
[/TR]
[TR]
[TD]8/27/2017[/TD]
[TD="align: right"]$416[/TD]
[TD="align: right"]86%[/TD]
[TD="align: right"]$45[/TD]
[TD="align: right"]150%[/TD]
[TD="align: right"]$384[/TD]
[TD="align: right"]162%[/TD]
[TD="align: right"]$8,120[/TD]
[TD="align: right"]140%[/TD]
[TD="align: right"]$338[/TD]
[TD="align: right"]75%[/TD]
[TD="align: right"]$729[/TD]
[TD="align: right"]97%[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$10,032[/TD]
[TD="align: right"]130%[/TD]
[/TR]
[TR]
[TD]9/3/2017[/TD]
[TD="align: right"]$495[/TD]
[TD="align: right"]119%[/TD]
[TD="align: right"]$128[/TD]
[TD="align: right"]284%[/TD]
[TD="align: right"]$177[/TD]
[TD="align: right"]46%[/TD]
[TD="align: right"]$8,241[/TD]
[TD="align: right"]101%[/TD]
[TD="align: right"]$307[/TD]
[TD="align: right"]91%[/TD]
[TD="align: right"]$691[/TD]
[TD="align: right"]95%[/TD]
[TD="align: right"]$436[/TD]
[TD][/TD]
[TD="align: right"]$10,475[/TD]
[TD="align: right"]104%[/TD]
[/TR]
[TR]
[TD]9/10/2017[/TD]
[TD="align: right"]$322[/TD]
[TD="align: right"]65%[/TD]
[TD="align: right"]$45[/TD]
[TD="align: right"]35%[/TD]
[TD="align: right"]$357[/TD]
[TD="align: right"]201%[/TD]
[TD="align: right"]$6,656[/TD]
[TD="align: right"]81%[/TD]
[TD="align: right"]$312[/TD]
[TD="align: right"]102%[/TD]
[TD="align: right"]$793[/TD]
[TD="align: right"]115%[/TD]
[TD="align: right"]$488[/TD]
[TD="align: right"]112%[/TD]
[TD="align: right"]$8,973[/TD]
[TD="align: right"]86%[/TD]
[/TR]
[TR]
[TD]9/17/2017[/TD]
[TD="align: right"]$312[/TD]
[TD="align: right"]97%[/TD]
[TD="align: right"]$31[/TD]
[TD="align: right"]69%[/TD]
[TD="align: right"]$291[/TD]
[TD="align: right"]81%[/TD]
[TD="align: right"]$6,720[/TD]
[TD="align: right"]101%[/TD]
[TD="align: right"]$326[/TD]
[TD="align: right"]104%[/TD]
[TD="align: right"]$656[/TD]
[TD="align: right"]83%[/TD]
[TD="align: right"]$374[/TD]
[TD="align: right"]77%[/TD]
[TD="align: right"]$8,708[/TD]
[TD="align: right"]97%[/TD]
[/TR]
[TR]
[TD]9/24/2017[/TD]
[TD="align: right"]$392[/TD]
[TD="align: right"]125%[/TD]
[TD="align: right"]$63[/TD]
[TD="align: right"]203%[/TD]
[TD="align: right"]$185[/TD]
[TD="align: right"]64%[/TD]
[TD="align: right"]$8,252[/TD]
[TD="align: right"]123%[/TD]
[TD="align: right"]$351[/TD]
[TD="align: right"]108%[/TD]
[TD="align: right"]$973[/TD]
[TD="align: right"]148%[/TD]
[TD="align: right"]$551[/TD]
[TD="align: right"]148%[/TD]
[TD="align: right"]$10,767[/TD]
[TD="align: right"]124%[/TD]
[/TR]
[TR]
[TD]10/1/2017[/TD]
[TD="align: right"]$366[/TD]
[TD="align: right"]94%[/TD]
[TD="align: right"]$31[/TD]
[TD="align: right"]49%[/TD]
[TD="align: right"]$251[/TD]
[TD="align: right"]135%[/TD]
[TD="align: right"]$6,234[/TD]
[TD="align: right"]76%[/TD]
[TD="align: right"]$367[/TD]
[TD="align: right"]105%[/TD]
[TD="align: right"]$873[/TD]
[TD="align: right"]90%[/TD]
[TD="align: right"]$483[/TD]
[TD="align: right"]88%[/TD]
[TD="align: right"]$8,605[/TD]
[TD="align: right"]80%[/TD]
[/TR]
[TR]
[TD]10/8/2017[/TD]
[TD="align: right"]$540[/TD]
[TD="align: right"]147%[/TD]
[TD="align: right"]$16[/TD]
[TD="align: right"]52%[/TD]
[TD="align: right"]$138[/TD]
[TD="align: right"]55%[/TD]
[TD="align: right"]$6,697[/TD]
[TD="align: right"]107%[/TD]
[TD="align: right"]$376[/TD]
[TD="align: right"]102%[/TD]
[TD="align: right"]$1,030[/TD]
[TD="align: right"]118%[/TD]
[TD="align: right"]$425[/TD]
[TD="align: right"]88%[/TD]
[TD="align: right"]$9,223[/TD]
[TD="align: right"]107%[/TD]
[/TR]
[TR]
[TD]10/15/2017[/TD]
[TD="align: right"]$551[/TD]
[TD="align: right"]102%[/TD]
[TD="align: right"]$41[/TD]
[TD="align: right"]256%[/TD]
[TD="align: right"]$198[/TD]
[TD="align: right"]143%[/TD]
[TD="align: right"]$6,865[/TD]
[TD="align: right"]103%[/TD]
[TD="align: right"]$379[/TD]
[TD="align: right"]101%[/TD]
[TD="align: right"]$1,889[/TD]
[TD="align: right"]183%[/TD]
[TD="align: right"]$723[/TD]
[TD="align: right"]170%[/TD]
[TD="align: right"]$10,644[/TD]
[TD="align: right"]115%[/TD]
[/TR]
[TR]
[TD]10/22/2017[/TD]
[TD="align: right"]$572[/TD]
[TD="align: right"]104%[/TD]
[TD="align: right"]$69[/TD]
[TD="align: right"]168%[/TD]
[TD="align: right"]$180[/TD]
[TD="align: right"]91%[/TD]
[TD="align: right"]$7,000[/TD]
[TD="align: right"]102%[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$5,400[/TD]
[TD="align: right"]286%[/TD]
[TD="align: right"]$1,500[/TD]
[TD="align: right"]207%[/TD]
[TD="align: right"]$14,721[/TD]
[TD="align: right"]138%[/TD]
[/TR]
[TR]
[TD]10/29/2017[/TD]
[TD="align: right"]$473[/TD]
[TD="align: right"]83%[/TD]
[TD="align: right"]$23[/TD]
[TD="align: right"]33%[/TD]
[TD="align: right"]$461[/TD]
[TD="align: right"]256%[/TD]
[TD="align: right"]$7,110[/TD]
[TD="align: right"]102%[/TD]
[TD="align: right"]$527[/TD]
[TD][/TD]
[TD="align: right"]$0[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]$8,999[/TD]
[TD="align: right"]600%[/TD]
[TD="align: right"]$17,593[/TD]
[TD="align: right"]120%[/TD]
[/TR]
[TR]
[TD]Grand Total[/TD]
[TD="align: right"]$13,723[/TD]
[TD][/TD]
[TD="align: right"]$1,868[/TD]
[TD][/TD]
[TD="align: right"]$11,041[/TD]
[TD][/TD]
[TD="align: right"]$183,343[/TD]
[TD][/TD]
[TD="align: right"]$4,259[/TD]
[TD][/TD]
[TD="align: right"]$13,783[/TD]
[TD][/TD]
[TD="align: right"]$13,979[/TD]
[TD][/TD]
[TD="align: right"]$241,996[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
I'm trying to insert the excel sheet but, it is not allowing me to do it.

Any way its B9 to Q66
 
Upvote 0
Begin by highlighting this range, then select conditional formatting, new rule, select "assign by formula" optio . In the textbox that comes up enter: = B9 = ""
Select format, Fill, Yellow, ok, ok...
Should work aftetwards...
 
Upvote 0
I'm trying to insert the excel sheet but, it is not allowing me to do it.
Click to expand...
If you read the text it tells you when you try to post that, you will note that it tells you that your post has been Moderated and needs to await Moderator approval - trying to post it again, does not change that. You just need to be patient and wait for Moderator approval. I have down that now, so you can see them above.

Posts from new members with images or code inserted often get Moderated. Once you have been here a little while, that will not happen anymore.
 
Upvote 0
Thank you so much Jim.

I'm coloring a pivot table using this. If i add one more column and refresh the pivot table, the blank cells in the newly added column wont appear in yellow color right? What should I do to automatically color the blank cells yellow when i add new columns or rows?

Please refer the data i attached in the previous reply.
 
Upvote 0
Expand the separate range which is titled: "Range to apply cf" to include your revised range... hope that helps... Jim
 
Upvote 0
You must log in or register to reply here.

Similar threads

O
  • Question Question
Conditional formatting for when one cell does not contain a + and another does = true.
2
Replies
11
Views
168
MARK858
MARK858
F
  • Solved
Colour all blank cells in a row if one cell in row has text.
Replies
3
Views
473
Joe4
Joe4
dannwid
  • Solved
Working with "< >" symbol inside the formula
Replies
5
Views
97
Peter_SSs
Peter_SSs
B
  • Solved
Macro to Open new tab and duplicate the data from the template, and rename new tab from cell value of template.
Replies
3
Views
619
mumps
mumps
T
  • Solved
Large Sheet-Need to Get blank cells to equal proceeding cell when blank
Replies
2
Views
71
TWTHOMAS
T

Forum statistics

Threads
1,224,825
Messages
6,181,189
Members
453,020
Latest member
Mohamed Magdi Tawfiq Emam

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top