Jul 28 2020 10:12 AM
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 subtract from an available balance of hours remaining.
In the attached example, let's say I notated that my associate used 8 bank hours on the 16th, I'd like to color the cell red and have it substract that amount from the current total value in D2.
Any help is greatly appreciated!
Jul 28 2020 10:36 AM
Hi @Cmears,
See attached file.
I used conditional formatting to fill the cell in red if a number between 0 and 500 in entered. That should cover it. Added a total hour at the end of your line too.
Jul 28 2020 10:50 AM
Jul 28 2020 10:57 AM
@Bennadeau - I feel like this should almost be a reverse conditional formatting with an If/Then function. Because I have separate categories of time off I would highlight a cell where an associate used "bank hours" red, then have it subtract from the D2 cell. I'd highlight another color if the employee used his "floating holiday", which would trigger a subtraction from E2. Hopefully that makes sense.
Jul 28 2020 11:09 AM
Jul 28 2020 11:22 AM
Jul 28 2020 11:59 AM
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)