Count green cells in Numbers on iPad

I am using an iPad 10th generation fully upgraded

My question is using numbers I show a task is completed by changing the cell to green.

The cells contain numbers but these are all different (10 cells)

i wish to count the number of green cells as they become green?

is this possible?

Apple Watch Series 7, watchOS 11

Posted on Nov 12, 2025 2:44 AM

Reply
Question marked as Top-ranking reply

Posted on Nov 12, 2025 6:07 AM

You cannot count cells based on color. Assuming each task is in its own row, I recommend you make a column of checkboxes to indicate when a task is complete. You can use conditional highlighting to create an automatic green background for the checked checkboxes.

2 replies

Count green cells in Numbers on iPad

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.