Cell formatting based dates that data is changed

[Lyndo]

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

[walruseggman]

So would your Oct-15 cell and everything below it be orange, or Nov-15 and everything below, or...?

[Lyndo]

sorry, the date column in the left is meant to be displayed as a label column only, the 25 projects are listed in the columns to the right of that column. I am looking for the cells with dollar amounts in them to turn orange if their values have changed since the PPM updated cell. I only took the screen shot of a single project to give a visual of what I am looking for. Sorry for the confusion.