sandwichgirl
New Member
- Joined
- Aug 13, 2007
- Messages
- 31
- Office Version
- 365
- Platform
- Windows
Hi
It's a long time since I've had a good excel puzzle and this one is a fun one.
I have a table that is made up of:
Column headers - w/c dates 17/10/2021 24/10/2021 31/10/2021 07/11/2021 14/11/2021
and rows with coloured cells (green and yellow) - green shows items in stock, yellow shows next stock expected - so they flow from green into yellow.
I would like to add a formula to the start of the row that identifies when the stock change date is forecast to happen based on the first cell of yellow
Is this possible?
I've found a VBA option that lets me sum the cells by colour - can I use this to do this too? The functions the VBA enables are =sumcellsbycolor() or =countcellsbycolor(). I don't know VBA myself, and rely on very helpful web pages to supply the code and how to info.
TIA
It's a long time since I've had a good excel puzzle and this one is a fun one.
I have a table that is made up of:
Column headers - w/c dates 17/10/2021 24/10/2021 31/10/2021 07/11/2021 14/11/2021
and rows with coloured cells (green and yellow) - green shows items in stock, yellow shows next stock expected - so they flow from green into yellow.
I would like to add a formula to the start of the row that identifies when the stock change date is forecast to happen based on the first cell of yellow
Is this possible?
I've found a VBA option that lets me sum the cells by colour - can I use this to do this too? The functions the VBA enables are =sumcellsbycolor() or =countcellsbycolor(). I don't know VBA myself, and rely on very helpful web pages to supply the code and how to info.
TIA