Forum Discussion
If/Then formula triggered by cell color
Good afternoon! I am trying to implement a staff calendar of sorts that keeps track of all available time off hours. I'd like to use a function that depending on the cell color chosen, would then sub...
I see how this could work, but it would make the spreadsheet significantly larger and I'm trying to keep this as concise as possible. I have four different categories of time off of an individual could use on any given day w/ 30+ employees.
Enclosed the file with a proposed solution ...
if the answer helped, then please tick as the correct answer so that others can also find out from it.
Nikolino
I know I don't know anything (Socrates)