Hello Again!
My supervisor wants me to create a column in a spreadsheet in Excel 2003 which tracks who has done what courses/who is nominated for them/who is enrolled etc etc BUT she wants it in a (ridiculous) format. Specifically:
P (MM/YY) - The P is for "pass", the date format and she wants it to automatically go green.
Enroll (MM/YY) - Yellow
Nom (MM/YY) - Light Blue
Blank - Red.
As you can see, it would need to be done in VBA somehow but I'm not sure how to set it up. Any help would be so great because she really wants it done ASAP and I am not so great with code. Thankyou so much for helping!
My supervisor wants me to create a column in a spreadsheet in Excel 2003 which tracks who has done what courses/who is nominated for them/who is enrolled etc etc BUT she wants it in a (ridiculous) format. Specifically:
P (MM/YY) - The P is for "pass", the date format and she wants it to automatically go green.
Enroll (MM/YY) - Yellow
Nom (MM/YY) - Light Blue
Blank - Red.
As you can see, it would need to be done in VBA somehow but I'm not sure how to set it up. Any help would be so great because she really wants it done ASAP and I am not so great with code. Thankyou so much for helping!