How To Dynamically Change Text Color Based On A Background Color

How to alter background or font color based on cell value in Excel?

When you bargain with huge information in Excel, yous may desire to option out some value and highlight them with specific background or font color. This article is talking about how to alter the background or font colour based on cell values in Excel quickly.

Table of Contents

Method one: Change background or font color based on jail cell value dynamically with Conditional Formatting

Method ii: Alter background or font color based on cell value statically with Detect function

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

Method one: Change groundwork or font color based on cell value dynamically with Provisional Formatting

The Provisional Formatting feature tin help y'all to highlight the values greater than x, less than y, or between x and y.

Supposing you lot have a range of data, and at present y'all need to color the values between 80 and 100, please do with the following steps:

1. Select the range of cells that you want to highlight certain cells, and so click Dwelling house > Conditional Formatting > New Dominion, come across screenshot:

doc highlight by value 1

2. In the New Formatting Rule dialog box, select the Format merely cells that incorporate detail in the Select a Rule Blazon box, and in the Format Just Cells with department, specify the conditions that you need:

In the first drop down box, select the Cell Value;
In the 2d drop downwardly box, select the criteria:between;
In the third and quaternary box, enter the filter conditions, such as 80, 100.

doc highlight by value 2

3. Then, click Format push, in the Format Cells dialog box, prepare the background or font color as this:

4. After select the background or font color, click OK > OK to close the dialogs, and now, the specific cells with value betwixt 80 and 100 are inverse to the certain the groundwork or font color in the choice. See screenshot:

Note : The Conditional Formatting is a dynamic feature, the cell color volition be inverse as the information changes.

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

Sometimes, you demand to use a specific fill or font colour based on cell value and brand the fill up or font color not change when the cell value changes. In this case, you lot can use the Find role to find all the specific prison cell values then change the groundwork or font color to your demand.

For example, you want to alter the background or font colour if the cell value contains "Excel" text, please practice every bit this:

1. Select the information range that you lot desire to use, and so click Home > Find & Select > Observe, see screenshot:

doc highlight by value 7

two. In the Find and Replace dialog box, under the Observe tab, enter the value that yous want to notice into the Find what text box, see screenshot:

doc highlight by value 8

Tips : If you lot need to find the values with case sensitive or match the entire cell content, please click the Options button to get the avant-garde search options, such as "Match Case" and "Match unabridged cell content" as you need.

iii. And then, click Find All button, in the find outcome box, click whatever i item, and and then printing Ctrl + A to select all found items, see screenshot:

doc highlight by value 9

4. At terminal, click Close button to shut this dialog. Now, y'all tin can fill a groundwork or font colour for these selected values, encounter screenshot:

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

Kutools for Excel's Super Find feature supports lots of weather condition for finding values, text strings, dates, formulas, formatted cells and then on. Subsequently finding and selecting the matched cells, you tin change the background or font color to your desired.

Subsequently installing Kutools for Excel, please do as this:

1. Select the data range that yous desire to detect, and then click Kutools > Super Find, run into screenshot:

doc highlight by value 12

2. In the Super Notice pane, delight practice the post-obit operations:

(1.) First, click the Values option icon;
(ii.) Cull the find scope from the Within driblet down, in this case, I will choose Selection;
(three.) From the Type driblet downwardly list, select the criteria that y'all desire to use;
(4.) Then click Find button to list all corresponding results into the list box;
(5.) At last, click Select push button to select the cells.

doc highlight by value 13

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

doc highlight by value 14

iv. And at present, y'all can change the background color or font colour for the selected cells as you need.

Busy work on weekend, Utilize Kutools for Excel,
gives y'all a relaxing and joyful weekend!

On the weekend, the kids are clamoring to become out to play, but there is too much work surrounds you to have time accompany the family. The sun, the beach and the sea so far away? Kutools for Excel helps you tosolve 80% Excel puzzles, save eighty% work time.

pic beach

Get a promotion and increase bacon are non faraway;
Contains 300 avant-garde features, solve 1500 application scenarios, some features even salvage 99% work time;
Become an Excel skilful in 3 minutes, and become recognition from your colleagues or friends;
No longer need to search solutions from Google, say goodbye to painful formulas and VBA codes;
All repeated operations tin can be completed with simply several clicks, free your tired hands;
Only $39 but worth than the other people's $4000 Excel tutorial;
Be chosen by 110,000 elites and 300+ well-known companies;
30-day free trial, and full money back within lx-mean solar day without any reason;
Change the fashion you work, and then change your life mode!