Conditional formatting in confluence

[Jason Skrzypek]

Hi Guys,

I have a table which produces a scores based on information entered into a scaffold form. Is it possible to change the cell or text colour based on the score value? For example is the score is below 40% this would turn red, 41%-60% this would turn orange and 61%+ would turn green. Ive started messing with Jquery which i know nothing about and probably heading in the wrong direction. I know the option is available in Excel (conditional formating) and was hoping someone would know how to do this with Confluence

Cheers

jason

[Kevin Buchs · Accepted solution]

Well, here a beginning of something you might try: put your scores on other pages, and make the text on each page be set to a color based on a label. The {include} all those pages into one master table.

other pages, for example Page a, Page b and Page c contain:

My number is {show-if:label=small}{color:blue}24{color}{show-if}{show-if:label=medium}{color:green}24{color}{show-if}{show-if:label=large}{color:red}24{color}{show-if}

Where the number of interest is 24 or others. Change the colors to match your requirements. Then label each page with one of "small", "medium", "large". The roll-up page can look like this:

|| Values ||

| {include:Page a} |

| {include:Page b} |

| {include:Page c} |

This will render a table with three colored numbers in it.

I tried to think of how I could combine this with the reporting plug in, but it spits out all the {show-if} macros.

[Jason Skrzypek]

based on this link http://community.customware.net/customware/topics/using_the_show_if_macro_with_scaffolding_data, ive created a text box where you can enter 1,2, or 3. The the report block produces text and a background colour based on the content. I just need to get this to work with the eval-data macro

|{text-data:test}{text-data}|

|{report-block}

{local-reporter:data:test}

{text-filter:@self|include=1}

{report-body}{bgcolor:yellow}test1{bgcolor}{report-body}

{text-filter:@self|include=2}

{report-body}{bgcolor:green}test1{bgcolor}{report-body}

{text-filter:@self|include=3}

{report-body}{bgcolor:blue}test1{bgcolor}{report-body}

{report-empty}Nothing is selected.{report-empty}

{report-block}|