Hi,
I have a report that uses conditional formatting to highlight each cell in a list 1 of 3 colours depending on the data in another column. ie
col1data is displayed col1col is used to set the colour.
Does any one know if there is an easy way at the end of this list to display a count of the number of times each different colour is used ie
col1 col2 col3
--------------------------------------------
Colour1 total: 5 7 6
Colour2 total: 2 0 1
Colour3 total: 3 3 3
--------------------------------------------