I have a workbook with a master worksheet that pulls data from other worksheets and totals them into a summary table with about 25 columns. The columns are broken up into months, where the costs for each month are summed from the other sheets.

At the top of each project column in the master sheet there is a date row which I manually enter with the last time I have updated another external system.

I want the month rows in the project to change to an orange fill when the date that the value changed is after the date that I updated the external system. I have about 25 projects that I would like this to occur on, and each will have a different "PPM spend updated" date. If I could click and drag and have it auto populate across the columns, or another method to avoid manual entry for each project, it would be advantageous but not essential.

I have had limited success with my VBA programming, issues have mainly came due to the cells displayed values coming from a formula rather than manual entry.

Any help is greatly appreciated!

\1