Firstly - apologies, I haven't even got a base code - because frankly I am hopeless.....
What I want to achieve - I will be running a weekly report from online and copying into Excel.
I have about 25 projects, each with numerous milestones (some have 1, some have 20). I want to have a summary on another page with the project number and a status box - where I have the project code (e.g. 12345), and if any of the milestones associated with that project are overdue, the project status box on the summary page is highlighted red.
The online report delivers milestone due date and current status (started, not started, complete).
So - for project 12345, if any milestone a, b, c, d, e, f is due before today, and the status is anything but complete, then on the second page the project status box highlights red.
If anything else, the box is green.