Home >Topics >excel >Excel sets date value to automatically change color when it expires

Excel sets date value to automatically change color when it expires

王林
王林Original
2020-02-29 15:06:3635387browse

Excel sets date value to automatically change color when it expires

Select the cells that need to be set in the table.

Excel sets date value to automatically change color when it expires

Then click the New Rule option under Conditional Formatting

Excel sets date value to automatically change color when it expires

Select the rule type and click Use formula to confirm the required settings Format the cell, then enter the formula =IF(ISBLANK($C1),0,IF($C1

Excel sets date value to automatically change color when it expires

After entering the format, switch to the font page, select the color you want to change in the color column, and click OK

Excel sets date value to automatically change color when it expires

Then click OK again on this page.

Excel sets date value to automatically change color when it expires

After clicking OK, you can see that the cells that meet the conditional formula will automatically change color.

Excel sets date value to automatically change color when it expires

Recommended tutorial: excel tutorial

The above is the detailed content of Excel sets date value to automatically change color when it expires. 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