Conditional Formatting: Number to change as cells are coloured


I am using Number to create a spreadsheet.

I am colour coding different cells based on number of guests not attending.

When I change their cell colour to Red, I would like my 'Total' cell (G2) to add up the number of Red cells so that I don't have to keep recounting every time I add Red cells.

Hope this makes sense!


Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!