In Microsoft Excel Which Color Is Blue-gray Text 2

-->

The far left of the spreadsheet is occupied by a picture of the actual color picker; this is the way it looks in Microsoft Office Excel 2010; the pickers in Word, PowerPoint, and Outlook are. We have sample text in an Excel sheet with the text “VBA Font Color” in cell B3 as shown below. As we can see the color of the font is default black color in nature. To apply the VBA code for changing the color of fonts for above-shown text, we need a module.

Summary

On the Microsoft Excel Formulas tab, we know that in the More Functions > Statistical category there is a function called COUNTIF which counts the number of cells within a range that meet a given condition. Criteria for that function are limited to text or numbers. However, using VBA we can create a function to count the number of cells with other criteria, such as cell color.

More information

Using VBA, a User Defined Function (UDF) can be created and saved into an add-in file so that it can be used in other workbooks and transferred to other computers.

How to create a UDF

Here are the steps to create a UDF to count cell color:

  1. Open Microsoft Excel, then press Alt+F11 to show the Visual Basic Editor (VBE) window.

  2. On the Insert menu, select Module to create a module. Then type the following script:

  3. Close the VBE window to return to Excel.

  4. In order to test the UDF, create example data that contains a column of cells in various colors.

  5. In cell D3, write the function:

  • In the 'range_data' argument, select cell C2 to C51.

  • In the 'criteria' argument, select cell F1.

  1. Press Enter. The result in cell F2 is 6. This means the number of cells shaded in blue is 6.

  2. You can test by using other colors. Change the color in cell F1 with any color you want from the data by using Home > Fill Color.

  3. You can also zip the UDF so that the function can be used in another workbook or on another computer. To do so, follow these steps:

    Step 1: Save The Workbook

    a. Select File, and then Save as. (Select Browse if needed.)

    b. Select Excel Add-In (.xlam) as the format and give the file a name, such as CountCcolor.

    Note

    You can save your Add-In file anywhere you want. But in order for it to be listed as an Add-In within your Excel program, save it to the default location. In Windows 7 the default location for any version of Microsoft Excel is: C:UsersRADDINIAppDataRoamingMicrosoftAddIns

    Step 2: Install the Add-In

    a. Open Microsoft Excel on the computer where you want to install the Add-In.

    b. Open the Add-Ins dialog box by selecting Excel Add-Ins for Excel 2013 and later on the Developer tab. (Add-Ins on Excel 2010.)

    c. In the Add-Ins dialog box, select Browse.

    d. Go to the file location where the Add-In file is saved (such as a USB drive or a cloud-based folder). Choose the file and then select Open.

    e. On the Add-Ins dialog box, make sure the add-in checkbox is unchecked. Then select OK.

In Microsoft Excel Which Color Is Blue-gray Text 2017

The Count Cell Color UDF is installed and ready to use. You will be able to access this function anytime by placing your cursor into any cell in the worksheet and typing:

Community Solutions Content Disclaimer

In Microsoft Excel Which Color Is Blue-gray Text 2016

MICROSOFT CORPORATION AND/OR ITS RESPECTIVE SUPPLIERS MAKE NO REPRESENTATIONS ABOUT THE SUITABILITY, RELIABILITY, OR ACCURACY OF THE INFORMATION AND RELATED GRAPHICS CONTAINED HEREIN. ALL SUCH INFORMATION AND RELATED GRAPHICS ARE PROVIDED 'AS IS' WITHOUT WARRANTY OF ANY KIND. MICROSOFT AND/OR ITS RESPECTIVE SUPPLIERS HEREBY DISCLAIM ALL WARRANTIES AND CONDITIONS WITH REGARD TO THIS INFORMATION AND RELATED GRAPHICS, INCLUDING ALL IMPLIED WARRANTIES AND CONDITIONS OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, WORKMANLIKE EFFORT, TITLE AND NON-INFRINGEMENT. YOU SPECIFICALLY AGREE THAT IN NO EVENT SHALL MICROSOFT AND/OR ITS SUPPLIERS BE LIABLE FOR ANY DIRECT, INDIRECT, PUNITIVE, INCIDENTAL, SPECIAL, CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSOEVER INCLUDING, WITHOUT LIMITATION, DAMAGES FOR LOSS OF USE, DATA OR PROFITS, ARISING OUT OF OR IN ANY WAY CONNECTED WITH THE USE OF OR INABILITY TO USE THE INFORMATION AND RELATED GRAPHICS CONTAINED HEREIN, WHETHER BASED ON CONTRACT, TORT, NEGLIGENCE, STRICT LIABILITY OR OTHERWISE, EVEN IF MICROSOFT OR ANY OF ITS SUPPLIERS HAS BEEN ADVISED OF THE POSSIBILITY OF DAMAGES.

To change a cell background, use one of the colors on the Background Color section.

Practical Learning: Painting the Background of Cells

  1. Start Microsoft Excel and open the DAWN Report2.xlsx workbook
  2. Right Cell C2 and click Format Cells...
  3. In the Format Cells dialog box, click the Fill property page.
    In the Background Color section, click a light blue color (5th column, 2nd row in the list)
  4. Click OK
  5. On the Ribbon, click Page Layout
  6. In the Sheet Options section, in the Gridlines section, remove the check mark of the Gridlines check box
  7. Press Ctrl + Home

Cell Formatting With Font

Introduction

A font is an art effect made of designed symbols used to represent letters and other characters on acell or a group of cells. A font is designed by an artist but usually follows a specific pattern. For example, a font designed to produce symbols readable in the US English language must be designed by a set of predetermined and agreed upon symbols. These English symbols are grouped in an entity called the English alphabet. When designing such a font, the symbols createdshould conform to a particular language.Because a font is primarily an art, one font can be different from another and a font is not necessarily a series of readable symbols.

Text

Just like everything else in the computer, a font must have a name. A font is also designed to assume different sizes. Before using it on aworksheet, the font must have been installed. Microsoft Windows installs many fonts during setup.Microsoft Office 2007 also installs new fonts when it is setup.

The font used on the Microsoft Excel application to display its menus and the names of objects is controlled by the operating system.Unless you have a good reason, you should not be concerned with it.

The names of fonts installed on your computer can be seen in the Fonts windowaccessible from Control Panel. Here is an example:

Microsoft Excel uses some default fonts to display the name of columns and rows on a worksheet. Another font is used by default to show the contents of cells. If you want to use a different font to display text in cells, you can changes these defaults. When changing the default font, in other words if you decide to change the defaultfont, you should use only the most popular fonts that are more likely to be found on your user’s computers.

To assist you with setting thefonts of columns, the ribbon is equipped with a Font section in the Home tab:

Practical Learning: Introducing Fonts

  1. Open the RTHS1.xlsx workbook:
  2. On the Ribbon Home if necessary.
    In Sheet1, Click cell B2 to activate it

The Name of a Font

You can make a worksheet user-friend by applying some fonts and colors to theircontent. A font is primarily known by its name as we saw in the above Fontswindow. When starting a worksheet,Microsoft Office Excel 2007 applies a default font named Calibri to the cells. If you want, you can change it.

To change the font used by a cell or a group of cells:

  • Click the cell to activate it or select a group of cells. On the Ribbon, click Home. In the Font section:
    • Click the arrow of the Font combo box and select thedesired font
    • Click the more options button . This would open the Format Cells dialog box with the Font tab activated. In the Font property page, use the Font combo box to select the desired font
  • Right-click a cell and click Format Cells. Select a group of cells then right-click the selection and click Format Cells. In the Format Cells dialog box, click the Font tab. In the Font property page, use the Font combo box to select the desired font

Practical Learning: Selecting a Font

  1. While Cell B2 is selected, in the Font section of the Ribbon, click the arrow of the Font combo box and select Bell MT
  2. Right-click Cell B3 and click Format Cells...
  3. In the Format Cells dialog box, click Font. In the Font property page, scroll down in the Font combo box and select Garamond
  4. Click OK
  5. Save the workbook

The Size of a Font

Besides its name, a font is also known for its size. The size defines how much height and proportional width would be used to represent the characters of the selected font.

To specify the font size used by a cell or a group of cells:

  • Click the cell to activate it or select a group of cells. On the Ribbon, click Home. In the Font section:
    • Click the arrow of the Font Size combo box and select thedesired size
    • Click the more options button . In the Font property page of the Format Cells dialog box, use the Size combo box to select the desired size
  • Right-click a cell and click Format Cells. Select a group of cells then right-click the selection and click Format Cells. In the Format Cells dialog box, click the Font tab. In the Font property page, use the Size combo box to select the desired font

When a font is installed, a set of font sizes is created in the Font Size combobox. You can use those numbers but you can also set a new one. To do this,instead of selecting a value in the Font Size combo box, type the desired numberand press Enter or Tab. The operating system would calculate the size and applyit.

Practical Learning: Setting the Font Size of a Cell

  1. On the worksheet, click Cell B2
  2. In the Font section of the Home tab of the Ribbon, click the arrow of the Font Size combo box (the top-right combo box of the Font section) and click 22
  3. Click Cell B3
  4. In the Font section of the Ribbon, click the more options button
  5. In the Font property page of the Format Cells dialog box, scroll down in the Size combo box and select 16
  6. Press Ctrl + S to save the workbook

The Style of a Font

In Microsoft Excel Which Color Is Blue-gray Text 2010

Another aspect of the appearance of a font is its style, which is a technique ofdrawing the characters of the text, depending on the font. This characteristiccomes in four options:

StyleExample
Regular Regular Text
BoldThis text is bold
ItalicItalicized section
UnderlineThe words are underlined

By default, Microsoft Excel appliesthe Regular font style to the cells of a worksheet. You can change this characteristic if you want. Tochange the font style of a cell or a group of cells:

  • Click the cell or select a group of cells on the worksheet. In the Home tab of the Ribbon, in the Font section,
  • Right-click a cell and click
  • Click the cell to activate it or select a group of cells. On the Ribbon, click Home. In the Font section:
    • Click the button that represents the desired style:Bold ,Italic ,or Underline
    • Click the more options button . In the Font property page of the Format Cells dialog box, select the desired option in the Font Style combo box
  • Right-click a cell and click Format Cells... Select a group of cells then right-click the selection and click Format Cells. In the Format Cells dialog box, click the Font tab. In the Font property page, select the desired style in the Font Style combo box

You can specify more than one style on a cell or a group of cells. To do this, click the buttonof the desired style. When a style is valid for a control, when you click thatcontrol, the style button is highlighted: ,or .To remove a style, click the undesired button. To add a style to another style,simply click the desired button. Based on this, you can have one, two or threebuttons highlighted in the combination of your choice.

Practical Learning: Formatting With Styles

  1. Still in Sheet1, click cell B2
  2. In Font section of the Ribbon, click the Bold button
  3. Click the arrow of the Font Color button and select Blue
  4. On the worksheet, right-click Cell B3 and click Format Cells...
  5. In the Format Cells dialog box, click Font if necessary.
    In the Font list, on the Font Style list, click Bold
  6. Click the arrow of the Color combo box and select Dark Blue, Text, Lighter 40%
  7. Click OK on the Format Cells dialog box
  8. Format the other sections as follows:
  9. Save the workbook

Cells Formatting With Styles

A formatting style is a set of font, font size, color, and patterns designed to make a worksheet or one of its sections look good. Microsoft Excel is equipped with categories of styles. You can use those ones or create your own.

When applying a style, you decide to format various cells at the same time using a category of style that has been predefined. Therefore, you apply such a style to a cell or range of cells. By default, when you are typing data in a worksheet, you are already using a predetermined style made of a certain font (Calibri), a font size (11), a border, and background, etc. You can modify this style or create a new one.

To apply a style, you use the Styles section of the Ribbon.

Practical Learning: Formatting With Styles

In Microsoft Excel Which Color Is Blue-gray Text 2018

  1. In Sheet1, select Cells B11:B17
  2. On the Ribbon, click Home if necessary. In the Styles, click the More button and select Output
  3. Select Cells B21:B32
  4. In the Styles section of the Ribbon, click the More button and select Output
  5. Select Cells C11:H17
  6. In the Styles section of the Ribbon, click the More button and click New Cell Style...
  7. Type Grades to replace the style name and click Format…
  8. In the Format Cells dialog box, click the Font tab. Change the font to Verdana, style Regular, size 10
  9. Click the Border property page
  10. In the Line Style section, click the thin line (1st column, 7th row)
  11. Click the Color combo box and select Tan, Background 2, Darker 10%
  12. In the Border section, click the top border, the bottom border, the left border, and the right border buttons:
  13. On the Format Cells dialog, click OK
  14. On the Style dialog, click OK
  15. Click Cell I11
  16. In the Styles section of the Ribbon, click the More button and click New Cell Style...
  17. Type Text Entry to replace the style name and click Format…
  18. In the Format Cells dialog box, click the Font tab. Change the font to Verdana, style Regular, size 10
  19. Click the Color combo box and select Blue
  20. Click the Border property page
  21. In the Line Style section, click the thin line (1st column, 7th row)
  22. Click the Color combo box and select White, Background 1, Darker 50%
  23. In the Border section, click the bottom border
  24. On the Format Cells dialog, click OK
  25. On the Style dialog, click OK
  26. Select Cells I11:J17
  27. In the Styles section of the Ribbon, click Text Entry
  28. Select Cells C5:D5
  29. In the Styles section of the Ribbon, click Text Entry
  30. Select Cells G5:J5
  31. In the Styles section of the Ribbon, click Text Entry
  32. Select Cells C7:D7
  33. In the Styles section of the Ribbon, click Text Entry
  34. Select Cells G7:J75
  35. In the Styles section of the Ribbon, click Text Entry
  36. On the Ribbon, click View
  37. In the Show/Hide section, click the Gridlines check box
  38. Save the workbook
  39. Complete the worksheet as follows: