Forum Discussion
VK3
2 years agoNew Member
Conditional Formatting a Matrix to Compare within Matrix Column
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 a...
Anonymous
2 years agoNot applicable
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
2 years agoNew Member
I think, Q1 still displays icon, also it should go with matrix, as I need categorization at Q level