Home>Article>Topics> How to create a contract management registration form in excel

How to create a contract management registration form in excel

爱喝马黛茶的安东尼
爱喝马黛茶的安东尼 Original
2019-08-21 14:56:32 15074browse

How to create a contract management registration form in excel

In order to facilitate management, the contract management table needs to be standardized first.

Finally, we need to manage the contracts by color: the background color of the contract that has expired is red; the background color of the contract that expires within 15 days is yellow; the other contracts have no change.

How to create a contract management registration form in excel

Select the area from D2 to D6, click "Start", "Conditional Formatting" in the menu bar, and click "New Rule".

How to create a contract management registration form in excel

Related recommendations: "excel basic tutorial"

In the pop-up new format rule, select "Use formula to determine the format cell", enter the formula =$D2-TODAY()

How to create a contract management registration form in excel

How to create a contract management registration form in excel

in the bulletin column, click "Format", and Modify the background fill color and font. Here, change the background color to yellow and the font to white and click "OK".

How to create a contract management registration form in excel

How to create a contract management registration form in excel

Select the area from D2 to D6 again, create a new rule, enter the formula =$D2

How to create a contract management registration form in excel

In order to verify the effect, we changed the date in cell D2 to February 18th, and you can see that the background color of the cell changes to red.

Finally achieved our effect: the background color of expired contracts is red; the background color of contracts expiring within 15 days is yellow; the remaining contracts have no changes.

How to create a contract management registration form in excel

The above is the detailed content of How to create a contract management registration form in excel. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article:How to wrap lines in Excel Next article:How to wrap lines in Excel