count highlighted fields

christopher ritzau 40 Reputation points
2026-10-02T18:37:36.5466667+00:00

count how many rows in column A are highlighted in yellow

Microsoft 365 and Office | Excel | Other | Windows
0 comments
Answer accepted by question author
EmilyS726 270.5K Reputation points Independent Advisor
2026-10-02T19:10:58.8166667+00:00

Excel formulas cannot directly count cells by fill color.

Fastest built-in method:

Select column A. Go to Data > Filter. Click the filter arrow in column A. Choose Filter by Color > Yellow.

Look at the status bar at the bottom of Excel. It will show the count of visible cells.

Was this answer helpful?

2 people found this answer helpful.

1 additional answer

Sort by: Oldest
Most helpful Newest Oldest
  1. christopher ritzau 40 Reputation points
    2026-10-03T09:35:11.4233333+00:00

    thank you very much

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.