In Excel, the condition format is used. When a value is selected from the drop-down menu, the color of the row changes.

Preface:

In Progress Management, when a row of jobs is finished

We will select a finished status,

When we select the final state, we often want the color of this line to become gray.

In this way, we no longer need to pay attention to this line of content.

 

How to implement:

In 1.2003, select a row first.

 

2. [menu bar --> format --> condition format]

[Menu bar --> Option-> option-based payment option]

 

3. The conditions include

Cell and formula options

Select a formula

(The purpose of selecting the formula is not only to change the color of the changed cell, but also to change the color of this row)

 

4. Formula Used

= Or ($ m22 = "finished ")

 

5. Then select the desired color.

--------------------------------------------

--------------------------------------------

Some differences in 2007

① The Position of the condition format is in the "first item" in the menu bar 」

 

② Select a range without having to start.

Because in the condition settings, "the range option"

In "applicability", we can select cells that change as the value of a cell changes.

 

 

-------------------------------------------

Extension:

In step 3, when we select cells, there are many useful options

For example, if the value is greater than this value

Between two values

And so on...

It is used for data processing.

 

Append description

Application 1: A Row changes color based on a value in the row.

When we want a line to change, use the formula$ G $19= 100%

 

Application 2. The frontend changes the color based on the values in the following columns.

When we want column F to change with the content of the nominal value in column G,

Use FormulaG19= "NG" (in this way, when the value of column G is Ng, the color of the previous column changes)

Drag the cell.