Forum Discussion
Matrix/Table formatting - BOLD row
- 6 years ago
Create a basic measure to give the row you need highlighted a value and then apply conditional formatting with a rule.
For example if i had this table:
Example V 1 V 2 A 1 5 B 2 6 C 3 7 D 4 8 suppose i wanted the row with all 'D' to be highlighted, i could create the following measure:
Measure = IF(Table[Example] = "D", 1, 0)
I can then apply the conditional formatting for each column using the rule and value =1
In conditional format use the rule and call that measure.
Regards,
Rajendra
- Anonymous6 years ago
I used Calculated column instead of measure and it worked.
Thanks for your help
Create a basic measure to give the row you need highlighted a value and then apply conditional formatting with a rule.
For example if i had this table:
| Example | V 1 | V 2 |
| A | 1 | 5 |
| B | 2 | 6 |
| C | 3 | 7 |
| D | 4 | 8 |
suppose i wanted the row with all 'D' to be highlighted, i could create the following measure:
Measure = IF(Table[Example] = "D", 1, 0)
I can then apply the conditional formatting for each column using the rule and value =1
In conditional format use the rule and call that measure.
Regards,
Rajendra
Conditional formats for tables and matrices do not include bold, italics, or font size/style (with the exception of font color). It seems as though the original post has not been addressed. Google results are scant on this topic.