How to condition format Datafields in Pivot with VBA?

[ongharry1014]

I have a Pivot table that looks like below. I need to conditional format just the WOS row to highlight cells that are less than 0 in red, 0.1 to 1.5 in yellow and anything above 1.5 in green. The pivot must keep the formatting when I move the pivot fields around. I have made various attempts on building a code but none of them works.

I wonder if anyone here could help me out with this. Thank you so much!

Site Code Values 10/16/2017 10/23/2017 10/30/2017 11/6/2017 11/13/2017 11/20/2017 11/27/2017 12/4/2017 12/11/2017 12/18/2017 12/25/2017 1/1/2018 1/8/2018 0875 Forecast 2049 615 406 397 395 415 441 420 427 424 388 369 375 Supply 2525 1280 0 640 0 640 320 320 640 320 320 320 640 Cumulative Delta 476 1141 735 978 583 808 687 587 800 696 628 579 844 WOS 1.08 2.75 1.78 2.39 1.43 2.01 1.72 1.45 1.97 1.70 1.56 1.50 2.29 0874 Forecast 772 418 418 418 418 446 555 554 555 555 275 274 275 Supply 2083 256 0 512 512 256 512 512 512 512 256 256 256 Cumulative Delta 1311 1149 731 825 919 729 686 644 601 558 539 521 502 WOS 2.77 2.35 1.55 1.82 2.11 1.76 1.79 1.81 1.83 1.86 1.76 1.68 1.60 32F2 Forecast 2026 469 256 250 253 247 235 223 229 226 242 230 237 Supply 1855 0 0 1280 0 640 320 320 320 0 320 320 320 Cumulative Delta -171 -640 -896 134 -119 274 359 456 547 321 399 489 572 WOS -0.63 -2.67 -3.76 0.57 -0.51 1.18 1.54 1.91 2.25 1.30 1.52 1.71 1.85 33SC Forecast 188 39 42 41 39 40 41 32 31 31 32 29 26 Supply 210 0 0 160 0 0 160 0 0 0 160 0 0 Cumulative Delta 22 -17 -59 60 21 -19 100 68 37 6 134 105 79 WOS 0.58 -0.46 -1.64 1.75 0.64 -0.61 3.46 2.50 1.46 0.25 6.20 5.28 4.55 Z201 Forecast 1000 224 110 140 110 139 181 180 181 181 45 45 45 Supply 1104 320 0 320 0 320 0 320 0 320 0 0 0 Cumulative Delta 104 200 90 270 160 341 160 300 119 258 213 168 123 WOS 0.66 1.31 0.62 2.03 1.28 3.02 1.66 3.74 1.87 5.45 4.47 3.53 2.58 <colgroup><col><col><col span="3"><col><col span="3"><col><col span="3"><col span="2"></colgroup><tbody> </tbody>

<colgroup><col><col span="3"><col><col span="3"><col><col span="3"><col span="2"></colgroup><tbody>
</tbody>

 

[ongharry1014]

Any help is appreciated!