I have a table report summing up project percentage allocations for individuals.
For instance, I could be working one project 10% of my time, another 70%, and a third 20%. My table would show me and the summary of my allocations - 100% in this case.
What I want to do is to highlight people with a summary value of anything other than 100%. If they’re 80% they get highlighted for under-allocation. If they’re 110% they get highlighted too.
I’ve been looking into the conditional formatting options and I can’t seem to find a way to make this work.
Thanks in advance for your help.