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