Forum Discussion
Remove Duplicates
Hi JofrainVisda
Unfortunately, we don't have an option to "merge cells" vertically as with Excel in tables.
So the scenario of hierarchial data should be presented with matrixes.
What kind of conditional formatting do you need to use?Hi JofrainVisda unfortunately as you mentioned you can only format the values.
The concept that you want, yet impossible.There is an idea about this issue you can vote for here:
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=b02bce75-4528-ec11-b76a-281878e62223i voted 🙂
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi JofrainVisda
Unfortunately, we don't have an option to "merge cells" vertically as with Excel in tables.
So the scenario of hierarchial data should be presented with matrixes.
What kind of conditional formatting do you need to use?
Hi Rita,
I would like to use the Conditional Background and font color. So I want the whole rows and columns of Business service excellence should have background color green, the whole rows and columns of One Manila Projects should be yellow. And percentage font color should be red or green if it hits the target.Hi JofrainVisda unfortunately as you mentioned you can only format the values.
The concept that you want, yet impossible.There is an idea about this issue you can vote for here:
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=b02bce75-4528-ec11-b76a-281878e62223i voted 🙂
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
