I have attached a sample file of what I'm trying to accomplish and hope that you can assist. I'm using Excel 2016 and have multiple tabs indicating each month.



In the Apr 17 tab, I need the users name in Column B to also appear in Column P for each instrument used.

Also, in the Q1 tab, I'd like to list the number of users in Column C and the initials of the users in Column D.

There is a cap to the amount folks will be charged for use so I need the color to change once the user has reached the annual cap amount.

What is the best way to do these tasks?

Thank you.

Attached Files

Sample ALM_Core_2017-18 (Detail).xlsx (99.9 KB, 13 views)