troubleshooting Question

How to distinguish between columns in MS Excel

Avatar of --TripWire--
--TripWire-- asked on
Microsoft OfficeMicrosoft Excel
4 Comments2 Solutions222 ViewsLast Modified:

I have a MS Excel spreadsheet that I'm helping develop for someone who is using it as a grading sheet.  I'm using someone else's version as a template.

There is room for 20 pieces of work from each student in the class (plus additional exams, etc.)  What he wants to do is be able to distinguish between the columns which assignments were coursework and which was homework, so that they may be weighted differently in the final grade.

If that explanation was confusing, consider this...

I have 20 columns, each with percentage marks in them.  The teach won't know until the school year begins where the homework will fall in the schedule and where the classwork will fall.  I want for him to be able to highlight the columns that were homework and 'mark' it somehow, so that a formula that I will provide will weight the HW differently than the classwork.

I hope that helps.  Please let me know if you need any further clarification.
Thank you.
Cost Accountant
Join our community to see this answer!
Unlock 2 Answers and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros