Be able to calculate the occurrences of cells with coloured background.
This is already possible in Excel today.
1. Press Ctrl+F to open the find dialog.
2. Click “Advanced”
3. Click on the “Format” button and select the format (cell colour) you want to count
4. Click Find All
The find dialog will list the count of occurrences of that formatting that you selected.
1 commentComments are closed
Frank Studley commented
At one time I could find access to this idea easily but now I am unable to find these back-ground colours for Good results, Bad results, average results etc,