Forum Discussion
Conditional Formatting on Total & Subtotals AND Centering the data in Total's
Hello All,
I am facing 2 issues -
1. I have conditional formatting on G% based on its value but the same is not available in TOTAL, how to apply the same in TOTAL as well?
2. I have made the table center aligned but TOTAL's are still right-aligned, is there any way to make alignment center as well?
Thanks,
hi Anonymous
1. Unfortunately, the conditional formatting does not apply for the subtotal and total in the current release desktop. Here is the idea, Please refer to it:
2. Look at the picture, please enable “Apply to subtotal” and “Apply to total” for the fields in Format->Field formatting, then it will work well.
Regards,
Lin
1 Reply
v-lili6-msftCommunity Support
hi Anonymous
1. Unfortunately, the conditional formatting does not apply for the subtotal and total in the current release desktop. Here is the idea, Please refer to it:
2. Look at the picture, please enable “Apply to subtotal” and “Apply to total” for the fields in Format->Field formatting, then it will work well.
Regards,
Lin