Keep Date Formatting When Changing Cell Colors in Excel
Question details
The user needs to change cell colors in Excel while keeping the cells displayed as dates.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Applying color coding to cells that contain dates.
- Observed behavior
- The date display changes to Accounting format after a color or style is applied.
Select one affected date cell and check its current format in Home > Number Format. If a style was copied from another cell, identify whether that source cell uses Accounting formatting.
Apply only a fill color instead of a complete cell style
Use this method when you want to manually color date cells without changing their number format.
The Fill Color command changes the cell background only. Pasting formats or applying a full Cell Style can also replace the existing date number format.
Click and drag to select the cells whose background color you want to change.
On the Home tab, open the Fill Color drop-down in the Font group and select the color you want.
If a selected cell already shows Accounting formatting, press Ctrl+1, open the Number tab, choose Date, select the preferred date format, and click OK.

Use Conditional Formatting to color dates automatically
Use this method when colors should change based on date values, such as overdue dates or dates in a specific range.
Remove copied formatting and reapply the date number format
Use this method when a pasted style or format has already changed date cells to Accounting.
Color Date Cells in WPS Spreadsheets Without Replacing the Date Format
WPS Spreadsheets lets you apply a fill color or create conditional formatting rules for date cells while keeping the selected date number format. Its familiar spreadsheet interface makes it easy to correct cells that were changed by a copied style.
- 1. Open the date range: Open the workbook in WPS Spreadsheets and select the cells containing dates.
- 2. Set the date number format: Right-click the selected cells, choose Format Cells, open Number, select Date, choose the required display, and click OK.
- 3. Apply a background color only: Go to Home > Fill Color and select a color for the selected date cells.
- 4. Create an automatic color rule if needed: Choose Home > Conditional Formatting, add a date-based rule, and set a Fill color without changing the Number format settings.

Frequently Asked Questions
Why did my Excel date cells change to Accounting format after I colored them?
The color action likely applied a full cell style, copied formatting, or a format painter setting that included an Accounting number format. Select the cells, press Ctrl+1, and choose Number > Date to restore the display.
Does Excel Fill Color change the value or date format in a cell?
No. Home > Fill Color changes only the cell background. A date format normally changes only when you apply a cell style, paste formatting, use Format Painter, or alter Number Format settings.
How can I highlight overdue dates without changing their date display?
Select the date cells, go to Home > Conditional Formatting > New Rule, set a rule such as dates before today, then click Format > Fill and choose a color. Leave the Number tab unchanged.
Can I copy a color from one date cell to another without copying its number format?
Use Home > Fill Color to choose the same color manually, or use Paste Special options that avoid formats. Do not use Format Painter or paste complete formatting if the source cell has a different number format.




