![]() GetFontColorIndex = pRange.Cells(1, 1).Font. The VBA code for the GetFontColorIndex function is: Function GetFontColorIndex(pRange As Variant) As Integer You can view the VBA code by pressing Alt+ F11. This formula returns the number of cells in range (A2:A12) that have a font color index of 3. To do this, we've created the following formula in cell D4: =CountFontColor(A2:A12,3) Next, we want to count how many cells have a red font in column A. ![]() This function returns 3 which is the color index for the red font used in column A, specifically cell A3. In cell D2, we've created the following formula: =getfontcolorindex(A3) To do this, we've created a function called GetFontColor. So first we need to determine the index number for the red font. In this example, we have values in column A that have a red font. How can I do this?Äownload Excel spreadsheet (as demonstrated below) For example, I want to count the number of cells that have a red font color. Question: In Microsoft Excel 2003/XP/2000/97, how can I count the number of cells that have a particular font color. Using this table, I show you how easy it is to insert an Excel Sunburst Chart using Excel 2016. This Excel tutorial explains how to count the number of cells with a particular font color in Excel 2003 and older versions (with screenshots and step-by-step instructions). How to Create a Sunburst Chart in Excel 2016 Example 1: In the table, you have sales data containing the month, week, region, and sales amount. MS Excel 2003: Count the number of cells with a particular font color
0 Comments
Leave a Reply. |