Feedback by UserVoice

How can we improve Excel for Windows (Desktop Application)?

colour cells

Be able to calculate the occurrences of cells with coloured background.

2 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Amy shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    already supported  ·  Dan Battagin [MS XL] responded  · 

    Hi Amy,

    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.

    Cheers,
    Dan [MS]

    1 comment

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • Frank Studley commented  ·   ·  Flag as inappropriate

        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,

      Feedback and Knowledge Base