Showing results for 
Search instead for 
Did you mean: 
Post Prodigy
Post Prodigy

Highlight Row Subtotal

Hi all,


Is it possible to highlight the row subtotals only?


When I do this all the grand totals are highlighted.


I only want the yellow lines highlighted below to be coloured.



Community Support
Community Support

Hi @HenryJS ,


Can you describe the requirement in detail, I didn't quite understand the information from this screenshot.


Best Regards,


Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
Super User
Super User

@HenryJS , in conditional formatting, you have the option of to apply to - Use total only and try

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin

Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

@amitchandak  that highlights all the right hand grand totals totals and not just to subtotal row

Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.