[sims] Colouring cells with mixture of text/no text

[SouthCoastSaint]

Posted on Supportnet - hopefully someone will have a solution for me.

 

We have previously colour coded RAG and used text to compliment in the cell.

 

So for example, if difference target/predicted is -6 then cell coloured amber and text in cell is -

 

SLT have decided that they wish to remove the text from SOME of the conditions, so we will just be left with + for over target and C for >12 points below. The other 3 conditions need to just display the colour and no text.

 

I have tried this two different ways and neither of them allow cells to show just colour with no text. I can't just colour the predicted grade as this then won't allow for the + and C to show.

 

Please help! Summary reports are due next week so it's very much a last minute change.

[vikpaw]

But isn't each of your conditions manually configured with a colour and text? It's not dynamic is it?

You should be able to delete the text for some conditions and leave it for others.

You might need to add another condition to cover all your options.

I think I'd need to see your conditional formula to make sense of it.

[SouthCoastSaint]

That was my exact thoughts when the idea was aired in the data meeting - I can do that, I will just delete the text where necesary. My conditions do work, but when I tried to amend them just by removing the text in the applicable statements but leaving the colour, the colour doesn't appear when calculating. It seems Sims doesn't 'hold' the blank there as when you re-open it, the radio button has gone back to the Column option. Unless I am missing something obvious...

 

Hmmm. Just thought of a possible obvious as I type. I have continued to use the Constant Value. I maybe need to adapt so that for the blank text conditions I somehow use the Column option. Off to try it now.

 

Thanks Vik for input.

 

** No. That didn't work either. The colour only seems to print when there is a text in the cell also.

Edited November 12, 2014 by SouthCoastSaint

[Shaner88]

I seem to remember reading somewhere on supportnet before that in the underlying coding for the NITE formula the colouring is associated with the text and so if there is no text to be displayed, there will be no colour displayed.

 

I have just used a full stop or comma as the text in the past when I have wanted to do colouring like this.

Edited November 13, 2014 by Shaner88

[vikpaw]

True. You'd have to use a character like a period. Or if it's just for the reports, you could try to conditionally hide the cell contents. As you sometimes want something to show, it's not so straightforward, but you can embed conditions in Word i think.http://support.capitaes.co.uk/newforum/main.asp?params=%95%9E%A1%9B%A0%A6%C8%A0%B0%A2%A4%B4%A9%8E%F1%98%94%90%9C%A8%AD%DC%90%AF%A1%91%E6%9B%D7%E7If the link doesn't work it's thread number 40981 Edited November 13, 2014 by vikpaw

[SouthCoastSaint]

I realised in the middle of the night when I was musing about this that I did forget to make it clear that yes, this is for individual reports. I will have a read of 40981 and see if I can attempt that. I did get around the initial problem by making a colour column and telling my original formula to colour that one and adding just my two text conditions, which worked fine in the marksheets, but it wasn't until I previewed a report that I could see it wasn't working.