Furniture has two subgroups if one of the subgroups contains red color, and the rollup should display red and similar to the Book too. I created a hierarchy to show the furniture and book which contains other subsets. but for total i can do a analytics to create a total but for condition formatting I am confused. Will appreciate any kind of support. Thank you very much in advance. If it is not clear please let me know, will try my best to simplify it.