Details as follows:
Column B – Project #
Column C-E (Merged) – Project description
Column F – Status
Column G – Project Details
Columns H-NI – Individual dates for the year
Each worksheet will list no more than 25 projects (currently rows 9 – 33)
Would appreciate the following assistance with the following 3 items (all columns would be included in the sorting noted below):
1. Sorting Macro:
A macro that will sort all items by project # when run (since projects entered may not flow in ascending order). (Assuming all projects are “On Track” – Green)
2. Highlighting cells:
There are three status types in the status column: On Track, At Risk and Off Track.
If status cell (in column F) displays On Track, Project Description Cell (Column C) would be green
If status cell (in column F) displays at Risk, Project Description Cell (Column C) would be light yellow
If status cell (in column F) displays Off Track, Project Description Cell (Column C) would be red.
3. Sorting Off Track or At Risk projects before On Track projects:
If a project is changed to Off Track or At Risk, a macro that I could run that (or could automatically run) that would override the “On Track” macro and list the Off Track or At Risk Projects before the On Track projects.
a. Any Off Track project would be listed before any At Risk project.
b. Off Track or At Risk projects would be listed in numerical order.