The easiest way I can visualise what you're trying to do would be to create a column on your data to represent the flagged rows and then use a row rule in the Table tool. A combination of summarises or Unique/Joins to flag that data and have a boolean column that effectively represents what you're going to highlight, then just apply that highlight based on that column. There may be another way but not off the top of my head.
The conditional formatting in excel that I think you would be using would act on a column with the result as a row, so it's 2 different aspects in one.
