I am using excel 2013. I have set up grouping based on the project name with the applicable details below. There is a formula in the details under the group that highlights the row to the color red which is OK. How do I get the row that contains the group to highlight as well when the detail row below it are highlighted as well? That when the details are hidden and the groups are just showing the group should be highlighted if any of the detail rows underneath the group are highlighted. How is this behavior controlled?