Conditional Formatting a Matrix to Compare within Matrix Column

Question

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 · Answer

Hi&nbsp;VK3&nbsp;
&nbsp;
I have understood about your problem, here is the solution I offer:
&nbsp;
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”.
&nbsp;

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

&nbsp;
Here is the result

Best Regards,
Nono Chen
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.
&nbsp;
&nbsp;
&nbsp;
&nbsp;