Recent content by BecJ

I have multiple charts with monthly compliance data (N/D) that then creates a column with the %compliance for that month. As I enter the data I want to automatically change the column with %compliant to a specific color. 90% and greater to green, 80% to 89% yellow and 0% to 79% red. I tried the...

I am trying to create a formula that takes a specific answer in a column then looks at a cell that has length of time and needs to be divided by a number. This formula also has to account for two different responses and if it is the second response there will be a different number it will be...