Hi
We are adding a column to our Progress Checks that shows average attitude to learning and want to colour code red if the average is between 1 and 3.99, yellow if between 4 and 5 and green if over 5. I have looked at Nested If Then Else and can't get it to work. Am I doing it wrong? Is there a way to do this? Thanks :-)