Conditional fomatting in SIMS Individual Reports

[AlisonMarlow]

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 :-)

[bobsmith]

that's exactly what you should be doing.

 

Can you post a screenshot of your nest if then else screen? (ALT+PrintScreen) should crop just that window for you.

[AlisonMarlow]

Hi Bob, thanks for your reply. It won't let me paste in a screen shot - would I be able to email it to you?

[AlisonMarlow]

Hi Bob, its not letting me attach a screen shot!!!! Grrrr. Would I be able to email it to you by any chance? Thanks

[limawhiskey]

Try https://pasteboard.co/