Forum Discussion
IF cell is coloured (any colour) count as 15 minutes and Sum as time durration
Hello, I'm using Excel as a roster planner /timeline of events. Is it possible to get excel to look at a range of preceding cells in one row and count each coloured cell (colours need to be diff...
It may be too tricky. My question is "why the colors in the first place? And how do they get into the cells in question?"
The reason for asking: is there another way to start that same logic in action by using letters or something else other than colors? (i.e., it sounds like you're trying to be tricky, or cool, with the colors, and in the process making it more difficult than it needs to be. Certainly, if a macro is needed to resolve this....)
Is it possible for you to upload a sample (after removing any real names) of what it looks like?