Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
2 questions please with a chart (its a straight table).
Please see attached - this is the table as it stands. Can anyone highlight how:
1) Whether we can make individual column headers a different colour? You will see the column 'target 15/16' where we have changed the individual rows but can't see how to do the header.
2) What the expression would be so the colour of the 'average mean score' would change dependent on whether it was a higher or lower than the target. For example as it stands New Homes 'average mean score' would be green as its higher than the 4.8 target (if it was less would want it to be red). I appreciate this is done on the visual cues tab but don't know what expression would be.
Any help would be grately appreciated.
Chris
Thanks for your help Rudolf and Rgv Rand.
Let see how it goes but looking good.
Hi,
Quick final question.
if([Target 15/16]<[Average (Mean Score)], Green(),Red())
The expression above works and scores red or green. Is there a way to make it not apply to the total?
There is no overall target so it shouldnt be green or red.
Chris
Hi
I am not sure this will work
But t ry with custom format cell .
Let me Check on it
Thanks