Hui, thanks for your response/welcome.
I have tried the selection of individual columns and changed the 10 to 80%, but that is not driven by the value inside the cells, seems only be driven by the number of cells.
Maybe the below will explain. 10 entries with values. Col Form80% will highlight...
I have a matrix that has Revenue value per Customer (thousands) and per Product Group (only 10). I want to highlight the top 80% of total value items per Product Group. I tried using Conditional Formatting, but that does not seem to work out well since it does not calculate to the total of each...