Does conditional formatting apply when column collapse?

Hello QS expert!

Is it possible to show Y/G/R light formatted when collapse a row? For example, if all rows are expended, the conditional formatting will apply properly. However, when collapse any row, the conditional formatted will be gone. (pls see screenshot). Thanks a ton!!

Hi @ChenjingLyu -
When you apply conditional formatting, by default it applies only to the lowest level of hierarchy. To make sure that conditional formatting applies when you roll up the hierarchy, you need to apply it by checking the Subtotals and/or Totals options. See screenshot.

Hope that helps!

Thank you Kellie so much for your guidance! I am able to follow your screenshot and make the change as desired!!