How to Change or Remove Colors in an Excel Student Schedule Template
Question details
The user wants to customize or remove the preset colors applied to classes and days in an Excel student schedule template.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Customizing the appearance of a pre-built student schedule template by modifying cell colors.
- Observed behavior
- Manual fill color changes do not apply to the schedule cells because existing conditional formatting rules override standard cell formatting.
Before modifying or deleting conditional formatting rules, it is highly recommended to save a backup copy of your original student schedule template so you can easily revert to the default colors if needed.
Manage Conditional Formatting Rules to Change Specific Colors
Modify the specific conditional formatting rules that control the automatic colors for individual classes or specific days without affecting the rest of the template.
Pre-built schedule templates rely on conditional formatting to automatically color-code cells based on text values (like a class name). To adjust these colors, you must edit the underlying rules rather than using the standard Fill Color bucket.
Click and drag to highlight the schedule table or the specific columns (such as Tuesday's classes) you wish to modify.
Navigate to the 'Home' tab on the top ribbon, click on 'Conditional Formatting', and select 'Manage Rules' from the drop-down menu.
In the dialog box, ensure 'Show formatting rules for' is set to 'Current Selection'. Scroll through the list to find the rule corresponding to the class or day you want to adjust.
Select the specific rule and click 'Edit Rule' to choose a new format/color, or click 'Delete Rule' to remove the automated color entirely. Click 'Apply' and then 'OK' to save your changes.

Clear All Conditional Formatting Rules from the Template
Use this method if you want to completely remove all automated coloring from the schedule and format the spreadsheet manually.
Customize Your Schedule Templates Easily with WPS Spreadsheet
WPS Spreadsheet fully supports advanced Excel templates and conditional formatting rules. You can effortlessly manage, edit, or clear format rules to customize your class schedule exactly the way you want it.
- 1. Open your template in WPS Spreadsheet: Launch WPS Office and open your downloaded student schedule template.
- 2. Access Conditional Formatting: Highlight your schedule table, then navigate to the 'Home' tab and click 'Conditional Formatting'.
- 3. Manage your rules: Select 'Manage Rules' to view all the active color codes applied to your classes.
- 4. Customize and save: Double-click any rule to change its color, or use the delete icon to remove it. Click OK and save your updated schedule.

Frequently Asked Questions
Why isn't the fill color changing when I try to highlight a cell in my schedule?
The cell likely has a conditional formatting rule applied to it by the template. Conditional formatting overrides manual fill colors. You must edit or remove the conditional formatting rule via Home > Conditional Formatting > Manage Rules to change the displayed color.
Can I apply different colors to each unique class in my schedule template?
Yes. You can create a new conditional formatting rule for each specific class. Go to Home > Conditional Formatting > Highlight Cells Rules > Text that Contains. Enter the class name and choose a custom format color for it.
How do I reset my schedule template back to its original preset colors?
If you haven't saved and closed the file yet, you can use the Undo button (Ctrl+Z) to revert your changes. If the file is already saved, you will need to download a fresh copy of the original student schedule template from your template source.




