SIMs Conditional Formatting

[jmel27]

Hi All,

 

I'm looking to essentially create a Conditional Formatted "Individual Report". I know in the marksheets, you can create Nested If Then Else formulas which show up cells as different colours (i.e Green for above target, Yellow for on target & Red for below target).

 

One of my colleagues is adamant that you can bring through these formulas onto an individual report.

 

Essentially what the school wants to produce is a simulated results day for Year 11 Mock Exams, whereby each student receives their mock results printed out, with each result highlighted in colour comparing it to their target, green, yellow or red as stated above.

Does anyone know if this is possible?

 

I assumed because the individual reports are generated in MS Word, that conditional formatting was impossible and that this cannot be done but my colleague seems to think that by somehow creating the formulas on the worksheet, they will pull through to an individual report.

I have tried but it doesn't seem to.

 

Thanks for any help!

[jdsa]

Absolutely you can, it works how you're describing it. Put the aspect that contains the Nested If Then Else formula in your Individual Report, make sure 'Print Report with Colour' is ticked, and the colour will come through.

[jmel27]

That's what I thought it would be, but I tried it and it just showed up the Mock Result, no colour.

 

I've calculated in the marksheet but even when I hit save, it doesn't keep the colours I have to recalculate every time I open it.

Is there some tickbox I'm missing somewhere?

[jdsa]

Just checking this is the process you're following:

Add a column for Data Entry using formula, select Result Set, choose Aspect and then the Nested If-Then-Else.

 

So for us, we have an Aspect for score, and then from that we have another Aspect with a formula that says, for example, if the score is above 110 then enter "GDS" and colour Green.

 

This should produce a permanent colour and text.

[jmel27]

That was where I was going wrong, I was making a Data Review using formula!

 

Thanks very much for your help, much appreciated!