Dear all,
I have a file which need macro to assist. I am quite new to it so I need you guys to help me urgently.
Inside my file have 6 sheets name as "MAIN", "DD","CD" , "DAE" & "UPDATE". "UPDATE" sheet will be updated every now and then.
Whenever "UPDATE" sheet updated, data in "MAIN", "DD" & "CD" sheet will be highlighted accordingly.
- if task accepted in "UPDATE" sheet but not completed, it will be highlighted with amber.
- if task accepted in "UPDATE" sheet and completed, it will be highlighted with blue.
- if task NOT accepted in "UPDATE" sheet but completed, it will be highlighted with blue.
- if task NOT accepted in "UPDATE" sheet and not completed, it will be highlighted with amber.
- IF TASK DOES NOT HAVE ANY STATUS IN ACCEPTANCE BUT COMPLETED, IT WILL BE HIGHLIGHTED WITH BLUE.
- if there is nothing enter in column C under acceptance, it will be highlighted with amber.
Do note that, the macro need to match data in column A & B before proceed with highlight. If data not match, it will continue check the next row and follow by sheet. Apologise first if my language confuse you guys, maybe the attachment will help to clarify.
Bookmarks