Where B10:C34 is the range in which you want to count the colors and B10 is a cell containing a font color to be counted. Then you can insert the following formula in a cell on the worksheet Here is a new reply that counts Font ColorsĬopy the code below and paste into the VBA editor. The code I provided counts interior (background) colors. I have re-read the question and I see that it is Font colors that you want to count.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |