How to use the menu function in Excel to calculate the number of blank cells of different colors?

You can use macros to add a custom function.

Press alt F11, right-click in the left window, select Insert Module, and then paste the following custom function content in the right window. FunctionColors(SRNGAsRange, XAsInteger)AsLong

DimArngAsRange

ForEachArngInSRNG

If = >EndIf

Next

EndFunction

After saving, enter =colors() in any cell, and you will be prompted that the function exists.

The usage of this function is:

=colors (selected area, color number)

For example: =color(A1:C10,10), See the picture below for the number corresponding to the color. This function determines the cell background color, not the cell font color. The toolbar and menu bar of office2010word are hidden and cannot be displayed no matter what. Please help me solve it. Thank you!

Right-click on the top ribbon, unminimize, and then click on the fixed ribbon in the lower right corner of the second picture. Wordexelpptpdftxt file, there is a blank item in the right-click menu, how to clear it? Other folders, etc. are normal.

Use 360 ??Security Guard’s system repair to repair it~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~