Forum Discussion
daisy8
Nov 29, 2023Copper Contributor
Transfer shading to different sheets
Hi, I am creating a spreadsheet to record badge achievements for a club. I would like to create one sheet to show overall achievements and individual sheets for each member. I would like to show t...
- Nov 30, 2023
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
Nov 30, 2023Gold Contributor
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.
daisy8
Nov 30, 2023Copper Contributor
Thank you for the time you have taken to answer my query.