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.
Select the area from D2 to D6, click "Start", "Conditional Formatting" in the menu bar, and click "New Rule".
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()
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".
Select the area from D2 to D6 again, create a new rule, enter the formula =$D2
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.
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!