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.
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.