Conditional Format Matrix Values

[jeve]

Hi All,

Is it possible to conditionally format the attached matrix chart so that the individual 'box' will highlight green if the % complete column is 100% in the table "Skyline"?

[Aree]

Hey @jeve 

You can conditional format any of the values column in a matrix table.

In my example i have 

ROWS = Customer

COLUMNS = Date

Values = Percentage

I use the conditional format Rule to set the background colour to be Red for any percentages >0.1 and <=0.11.

Hope that helps mate.

[jeve]

Hi Aree,

The problem I've got is that I'm dealing with text, not numbers, that require formatting. 

Essentially I need the formatting to format the text depending on the corresponding % column in the Skyline table. My initial request was to highlight if the % column = 100%. Eventually I'll need to have different colour codes for different values in columns that will be added at a later date. For example, % column = 100% and "certificate issued" column (to be added later) contains a date (not blank).

Can conditional formatting lookup values in corresponding cells and format accordingly, per those values?

[Aree · Accepted solution]

Hey @jeve 

This is as close as you can get with the data you have as far as i can see.

As you can see i can colour a column based on its value but when you place that column into a matrix then this value is part of an aggregation. You will notice that the one row that has a completed and wk ending date is coloured but since all other columns who are missing a value for completed and wk ending date get bundled together and hence get colour too.

This is the missing pieces in your data.

If you get those blanks filled in you can use thise approch to colour your fields.

I use the approach of using a field value within the conditional formatting and this value is generated via an if statement. 

hope this helps mate.