dannyok90
Board Regular
- Joined
- Aug 30, 2016
- Messages
- 115
Hi Guys!
Happy Friday! (for people in time zones 0+10/0-10) haha
I usually like to come to the board with something I've had a go at myself first, to at least bring a starting point!
this time though im looking for abit of advice and help
id like to put a date selector in a cell that has options so date and four options (one selection must be made only) are available..
so when you click a cell you choose the date and then either NH, NHDT, EPDT, LRM (these abbreviations are locations)
the date will be displayed in the cell and the abbreviation in the cell next to it, then I can use conditional formatting to color code the date.
Any Ideas, I've tried using the Microsoft date time picker and I guess that's okay but I have no idea where to start adding the options.
im open to suggestions if anybody has a better idea or method of doing it.
Thanks Guys!
Danny
Happy Friday! (for people in time zones 0+10/0-10) haha
I usually like to come to the board with something I've had a go at myself first, to at least bring a starting point!
this time though im looking for abit of advice and help
id like to put a date selector in a cell that has options so date and four options (one selection must be made only) are available..
so when you click a cell you choose the date and then either NH, NHDT, EPDT, LRM (these abbreviations are locations)
the date will be displayed in the cell and the abbreviation in the cell next to it, then I can use conditional formatting to color code the date.
Any Ideas, I've tried using the Microsoft date time picker and I guess that's okay but I have no idea where to start adding the options.
im open to suggestions if anybody has a better idea or method of doing it.
Thanks Guys!
Danny
