May 10, 2005 #1 RandDUser Technical User Joined Feb 24, 2005 Messages 65 Location US Is there a way to run a COUNTIF formula to count the number of cells with green font in a range of cells? Thank you
Is there a way to run a COUNTIF formula to count the number of cells with green font in a range of cells? Thank you
May 10, 2005 #2 xlhelp Instructor Joined Dec 7, 2001 Messages 2,976 Location CA Not using functions. It can be done using VBA. Here is a link to solution by Chip Pearson http://www.cpearson.com/excel/colors.htm http://www.geniusmedia.ca Upvote 0 Downvote
Not using functions. It can be done using VBA. Here is a link to solution by Chip Pearson http://www.cpearson.com/excel/colors.htm http://www.geniusmedia.ca
May 10, 2005 Thread starter #3 RandDUser Technical User Joined Feb 24, 2005 Messages 65 Location US Thank you, this works great! Upvote 0 Downvote