katbanham

Ah okay! I have been to a school where they managed to do it but I cant remember how - they definitely used a formula column in the marksheet.

Unfortunately not, we create reports in SIMS that link directly to the marksheet aspects.

We had so many phone calls from parents that we ended up sending out an email informing parents of the change and telling them to WATCH THE GUIDANCE VIDEO!! We also attached a guidance document incase they didn't have patience to watch the short video!

Hi all, I'm hoping someone can help me with this: We want to start sending reports home with colour coding instead of grades which we will extract from an aspect in a marksheet. However, I'm not sure how to create a column that will remain blank but will colour depending on a grade that is entered into a different column. For example: [TABLE=class: grid, width: 400] [TR] [TD]Name[/TD] [TD]Strand A01[/TD] [TD]Strand A01 Colour[/TD] [/TR] [TR] [TD]Bloggs, Fred[/TD] [TD]Emerging[/TD] [TD](blank but coloured red)[/TD] [/TR] [TR] [TD][/TD] [TD][/TD] [TD][/TD] [/TR] [/TABLE] 'Strand A01 Colour' is the aspect that I would pull through into the report. I am familiar with formula columns and have tried a few to no avail. Can anyone help? Thanks!