I need to apply background color to the certain conditional records in tablular chart. I have attached a workbook with data and worksheet as reference.
The condition is: All Brands coming under Parent "Amazon" need to have Red background, the rest of the Brands can remain as white. In addition, there is also a light green to dark green coding on the Spend values.
The 1st field AmazonBrandSpend distinguishes between Amazon and other Brands.