Does conditional formatting apply when column collapse?

Question & Answer
1

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!!

image (2)
image (2)1040×139 15.2 KB

image (1)
image (1)949×133 17 KB

2

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.

conditional formatting hiearchy
conditional formatting hiearchy1410×568 99.1 KB

Hope that helps!
Kellie

3

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