Hello!

I have a data table that I need to sort on multiple levels (i.e. Organise by same Location, and then by Gender, and then by Age) and I want to group them.

Then I want to take each group and look at a fourth column and highlight the whole group if the fourth column contains a "zero" in a cell on its own (versus just containing a "zero" like in a "10", "205", or "3008").

Looking at the fourth column for a lone zero, I'd like to apply an if statement (maybe?), where in the possible presence of a lone zero, I'd like to highlight or signify the whole group.

Any suggestions for what I should look into? Should I multi-level sort by the first three columns? Any suggestions on how to apply an if statement to a whole group by looking at just one column value? Or is there another way?

Thanks very much!!