As students enroll or complete courses, the course numbers and prefixes could be placed in column A (A11:A67), column E (E11:E58), and column F (F11:F58) of the Program of Study worksheet. I want to make sure that if any course is listed twice (duplicated) in any of these cells in the Program of Study Worksheet that it is "flagged" (for example, the cells will highlight red where the courses are duplicated). How can I accomplish this? Thank you for your help!
As there is already red highlighting for the blank cells in column A I formatted the following conditional formatting using amber:Formula:
Please Login or Register to view this content.
Similar formulas are also applied to columns E:F
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Thank you this is perfect.
Tangent: FWIW, I took Algebraic Topology in my junior fall, Differential Topology in my senior spring, and both had the same course designation, Mathematics 74, Special Topics in Topology.
I realize you're only flagging duplicates, but in some schools in some departments, course designations are used for multiple distinct classes and may be taken multiple times.
You are absolutely correct. I had the same experience in pursuing my graduate degree as well. In our department, that is not the case albeit I have tried to lobby for that kind situation.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
You're Welcome and thank you for the feedback. As Ali states, please take a moment to mark the thread as 'Solved'. I hope that you have a blessed day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks