What should I do if excel changes color after inputting content?

#What should I do if excel changes color after inputting content?

As shown in the picture, when I enter samples in column D of the Excel table, it displays "blue" and when I enter orders, it displays "red". I want to cancel this function

Recommended: "Excel Tutorial"

First, select column D

Click "Conditional Formatting" in the start menu and click "Manage Rules" in the drop-down menu

At this time we can see that the reason why the font changes color is because Rules are set in conditional formatting

Check the box on the right side of the rule

and then click " Delete rule"

After deleting, click the "OK" button at the bottom of the dialog box

At this time we see D The font in the column has no color

The above is the detailed content of What should I do if excel changes color after inputting content?. For more information, please follow other related articles on the PHP Chinese website!