Re: If/Then formula triggered by cell color

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.