22 Sep 2015 at 11:55 #1 Django x2 Django x2 Soldato Joined 28 Sep 2008 Posts 14,190 Location Britain Sup Forumites, Can I CountIf cell style is good (ie green)? Thanks
22 Sep 2015 at 12:07 #2 gord gord Soldato Joined 18 Oct 2003 Posts 19,415 Location Midlands edit: well, I completely misinterpreted that question.. As andshrew says, but if you can use the criteria for what makes a cell green you may be able to use that without VBA. Last edited: 22 Sep 2015
edit: well, I completely misinterpreted that question.. As andshrew says, but if you can use the criteria for what makes a cell green you may be able to use that without VBA.
22 Sep 2015 at 12:13 #3 andshrew andshrew Soldato Joined 25 Oct 2002 Posts 2,662 You can't sum or count based on colour - you need to use VBA or an add-in. There's lots of examples here.
You can't sum or count based on colour - you need to use VBA or an add-in. There's lots of examples here.
