Report

Conditional Formatting: Number to change as cells are coloured

Hello,

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!

Thanks!
See more 

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!