Forum Discussion
Transfer shading to different sheets
You can ignore that last posting. Here's a greatly improved version (still retaining versions 1 and 2 if you're curious).
In the tab called "version 3" I have added the color when there's a value in the cell under award or time. This also uses a slightly simpler formula, although still retaining the LET function to make it a bit shorter.
Hi, mathetes
Thank you for your reply.
I have attached a sample workbook.
The password is Tif2nrpr#
A brief explanation of the system I am using; the achievements are grouped into themes which have a different colour. Participants are required to earn a level award and attend a certain number of sessions in order to achieve the award for that theme.
The cells beneath the subheadings would need to be colour-coordinated for ease of use. Once the achievement has been gained, the shading would be changed to the corresponding colour and remain that colour to show it had been completed.
As you mentioned in your reply, there would then be several sheets following the first, one for each individual. These will need to contain the same information as the first for each individual. I will also need to transfer some number data (just numbers, no formulas) to the individual sheets to show the minutes each individual had attended.
I hope that is sufficient information for you but please do ask if you need more detail.
Thanks again for your help.
My knowledge of Excel is very basic but I'm keen to learn 🙂
Daisy
I'm not sure exactly why this is happening, though I have a hypothesis. When I clicked on your link and entered the password you provided this screen showed up
My hypothesis is that too many folks here in this forum have tried to enter it---it may take only a few--and that triggers this locking response. So I'd strongly suggest you get yourself out of trouble by removing the link (in fact I'll notify the administrators of this site to do so, if you don't get there first).
If the sheet you're linking has real names, create a dummy version of it without real names and then share it without requiring a password.
It is a dummy workbook with fictional names.
In fact, I simplified the workbook right down so that only the two queries I wanted solved were shown.
I don't know how too much traffic could be an issue as it is only yourself I have had a response from.
However, another person has managed to share the link to the dummy workbook so hopefully you should be able to access it through him.
I haven't done the colorizing yet, but wanted to show you this.
You will need a relatively new version of Excel, as this makes use of the FILTER and LET functions.
As you'll see, it's not necessary to have separate sheets for each individual. Assuming you're just going to print one for Bluey, another for Bingo, another for Chili, etc, you can simply select the name on one of the two sample sheets I've given you (the one titled "Version2" is the cleaner) and it does the work of getting that person's data.
You can ignore that last posting. Here's a greatly improved version (still retaining versions 1 and 2 if you're curious).
In the tab called "version 3" I have added the color when there's a value in the cell under award or time. This also uses a slightly simpler formula, although still retaining the LET function to make it a bit shorter.
mathetes , file is here
