Conditional Formatting a Matrix to Compare within Matrix Column

[VK3]

Instead of Icons displying in all three Q's, I  need it only in Q2 and Q3. Also, the icons should be displayed with respect to Q1 values. For Eg. in Row a (with q1 value, q2 should have green arrow and q3 should have red arrow). Is this possible?

[Anonymous]

Hi @VK3 

I have understood about your problem, here is the solution I offer:

Based on the style you provided, this seems to be a table and not a matrix. You can create a table visual

Right-click on the column you want to add an icon to and select the “Icons” under “Conditional formatting”.

Here you can add rules to display icons, add rules for Q1, Q2, and Q3 respectively

Here is the result

Best Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[VK3]

I think, Q1 still displays icon, also it should go with matrix, as I need categorization at Q level