When adding colours within a cell in a marksheet, (right clicking on the cell “Select colour to a cell”) the colour will NOT pull into individual reports. If you want the colour to pull into an individual report along with the result, it will need to be coloured using a Nested If Then Else formula…
Columns relating to statutory guidance are displayed with a green background and can be identified by the letter Y in the PoS Expectations heading. Columns that relate to non-statutory guidance are displayed with a pale blue background and can be identified by the letter N in the PoS Expectations heading. Columns relating to user-defined resources…
Is the ‘Print Report with Colour’ option ticked? Was the colour added retrospectively to the marksheet? Is the column marked read only or its associated result set locked? If so the marksheet will show the colour but it is not saved for reports. KB19315
This will enable you to colour code the percentage attendance within a marksheet so that you can report on percentage attendance within an Individual Report for parents. Example: Above 95% is green Between 90%-95% is yellow Below 90% attendance is red Create an aspect called “Attendance Traffic Light” (Focus/Assessment/Aspect and click on new) ….