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...
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.
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.
