B bcally15 New Member Joined Dec 7, 2005 Messages 2 Dec 7, 2005 #1 Probably a lay up for someone here but how would I write a countif if formula if criteria was based the color of the cells in my range? thanks
Probably a lay up for someone here but how would I write a countif if formula if criteria was based the color of the cells in my range? thanks
Mark O'Brien MrExcel MVP Joined Feb 15, 2002 Messages 3,530 Dec 7, 2005 #2 Welcome to the board! I don't believe that you can do what you want with built-in Excel functions, but Dave Hawley at OzGrid has a nice write-up on a VBA solution for your problem: http://www.ozgrid.com/VBA/Sum.htm I hope this helps.
Welcome to the board! I don't believe that you can do what you want with built-in Excel functions, but Dave Hawley at OzGrid has a nice write-up on a VBA solution for your problem: http://www.ozgrid.com/VBA/Sum.htm I hope this helps.