Forum Discussion
highlight specific rows in matrix
Hi All, I have a table and would like to be able to highlight certain rows. I would like to be able to bold or use a background colour on the bolded items like revenue and profit (as shown below...
You can use conditional formatting but you will need to apply it to each column in your table:
Formatting = IF(SELECTEDVALUE('Table'[Column2]) = "qd" ; 1 ; IF( SELECTEDVALUE('Table'[Column2]) = "2q" ; 2 ; 0 ))
Hope it helps,
J
Hi Anonymous
you can create a column (column1 in my example) in this table which will have value="red" for your selected columns and be blank for other.
then use the conditional formatting function (vizualization pane - values - column - conditional formatting - background):
Result will look like this
do not hesitate to give a kudo to useful posts and mark solutions as solution