Conditional Formatting & Subtotal Macro

[KJones97]

Hi All,
I am trying to build a conditional formatting macro at the end of a string I already have that will help visualize the data represented. The data is located (A12:V750) but the conditional formatting will apply to Column F (I am hoping to have the highlighting apply to the whole row though A:V). All the data in column F follows the same format "#.### MMM dd yy" MMM stands for month ex. JUL, AUG, SEP. For example F12 = 4.000 JUL 03 19. The first portion of the macro already filters the data so all rows with the same month are adjacent.

I would like to conditionally format the rows to color fill each month separately. The problem is when I pull new data for next month the first value in column F will no longer be in the month of July but August, and so on. (The color of each fill does not matter)

I only need the first 6 months to be conditionally formatted but would like to subtotal the sum of column J by month throughout the range. I only need the first 6 months formatted because further down the list JUL will appear again but for the year 2020.

Let me know if you need anymore information I am usually pretty bad at these things and thank you in advance for the help I really appreciate it.

KJones

 

[KJones97]

One piece of information that might help as well. The date of the data pull is in cell P2 in the format yymmdd. If that helps with discerning which months will follow. For example the last date I pulled was 190630 (June) which means the first date in cell F12 will be in the month of July. The data pull will always occur on the last day of the month.