Feature Summary

The font color feature is used to set the color of cell text, making important content more prominent, facilitating the differentiation of various data types, and enhancing the readability and aesthetics of the spreadsheet.

Feature Description

Feature Dimension Description
Membership Restriction No membership restriction
Version Restriction No version restriction

Operation Steps

Setting Font Color via the Ribbon

Feature Entry
"Home" tab → Drop-down arrow next to "Font Color"

  1. Select the cell or partial text within a cell for which you want to modify the font color
  2. Click the Font Color button (capital letter icon with a color underline) in the Home tab
  3. Click the icon to directly apply the most recently used color
  4. Click the drop-down arrow next to the icon to open the color panel and select a color

Click "More Colors" to customize a color code

截图

Setting via Right-Click Menu Format Cells Dialog

Feature Entry
Right-click menu → "Format Cells" button → "Font" tab → "Color" drop-down menu

  1. Select the target cell, right-click and choose the Format Cells button
  2. In the pop-up window, switch to the Font tab
  3. Select the font color in the Color drop-down box

Click "More Colors" to customize a color code

  1. Click OK

截图

Setting Font Color via the Format Cells Dialog

Feature Entry
"Home" tab → "Font Settings" arrow icon → "Font" tab → "Color" drop-down menu

  1. Select the cell or partial text within a cell for which you want to modify the font color
  2. In the pop-up window, switch to the Font tab
  3. Select the font color in the Color drop-down box

Click "More Colors" to customize a color code

  1. Click OK

截图

Frequently Asked Questions

Q1: How to customize the font color?

  • Solution: Click the "Font Color" drop-down arrow, select "More Colors", and in the pop-up dialog, you can customize the color using RGB values or Hex color codes.

Q2: What is the difference between font color and cell fill color?

  • Solution: Font color is the color of the text itself, while cell fill color is the color of the cell background. Both can be set simultaneously.

Notes

  • Font color should contrast with the cell background color to ensure text is clearly legible
  • It is recommended to use light-colored fonts on dark backgrounds and dark-colored fonts on light backgrounds
  • You can set a different color for partial text within a cell