Hi All,
Attached is a highly simplified worksheet showing the core concept of what I am trying to achieve for this dashboard but the actual correct coding is eluding me.
What I need this to do is:
The sheet labeled "dash" should reflect the status of the most tardy subtask under the sheet "data". Ie. for Task 1 in the month of October, the "dash" sheet cell "B2" should be colored yellow since the most tardy subtask (1.1) in October is yellow and the others (1.2,1.3) are green. Likewise, if a subtask for that month is red, the "dash" sheet status for that month should be red. So the dashboard displays the worst performing of those subtasks for the month.
I can do basic cell color changes in VBA based on other colors but making a code that will select the "most tardy" status from the subtask column and reflect that one color in the "dash" sheet status has me a little lost. Any help or guidance is welcome!
Bookmarks