Method 2: Change background or font color based on cell value statically with Find function

Sometimes, you need to apply a specific fill or font color based on cell value and make the fill or font color not change when the cell value changes. In this case, you can use the Find function to find all the specific cell values and then change the background or font color to your need.

For example, you want to change the background or font color if the cell value contains “Excel” text, please do as this:

1. Select the data range that you want to use, and then click Home > Find & Select > Find, see screenshot:

2. In the Find and Replace dialog box, under the Find tab, enter the value that you want to find into the Find what text box, see screenshot:

3. And then, click Find All button, in the find result box, click any one item, and then press Ctrl + A to select all found items, see screenshot:

4. At last, click Close button to close this dialog. Now, you can fill a background or font color for these selected values, see screenshot:

Apply the background color for the selected cells:	Apply the font color for the selected cells:

Method 3: Change background or font color based on cell value statically with Kutools for Excel

Kutools for Excel’s Super Find feature supports lots of conditions for finding values, text strings, dates, formulas, formatted cells and so on. After finding and selecting the matched cells, you can change the background or font color to your desired.

After installing Kutools for Excel, please do as this:

1. Select the data range that you want to find, and then click Kutools > Super Find, see screenshot:

2. In the Super Find pane, please do the following operations:

• (1.) First, click the Values option icon;
• (2.) Choose the find scope from the Within drop down, in this case, I will choose Selection;
• (3.) From the Type drop down list, select the criteria that you want to use;
• (4.) Then click Find button to list all corresponding results into the list box;
• (5.) At last, click Select button to select the cells.

3. And then, all cells matching the criteria have been selected at once, see screenshot:

4. And now, you can change the background color or font color for the selected cells as you need.