Formatting Issues

Keep Date Formatting When Changing Cell Colors in Excel

Bushra ParveenBushra Parveen Nov 12, 2026 868 views

Question details

The user needs to change cell colors in Excel while keeping the cells displayed as dates.

Keep Date Formatting When Changing Cell Colors in Excel
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.
Before you start

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.

Solution 1Recommended

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.

1
Select the date cells

Click and drag to select the cells whose background color you want to change.

2
Choose Fill Color

On the Home tab, open the Fill Color drop-down in the Font group and select the color you want.

3
Restore the date format if needed

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.

Apply only a fill color instead of a complete cell style
Date display preserved: Using Home > Fill Color changes the background without replacing the date number format.
Format dates without changing their display

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. 1. Open the date range: Open the workbook in WPS Spreadsheets and select the cells containing dates.
  2. 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. 3. Apply a background color only: Go to Home > Fill Color and select a color for the selected date cells.
  4. 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.
Apply fill colors without overwriting the date number format.Create conditional formatting rules for overdue, upcoming, or date-range cells.Open, edit, and save Microsoft Excel .xlsx and .xls files with format compatibility.Use a familiar, lightweight spreadsheet interface for Excel-style formatting tasks.
microsoft office alternative - wps office

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.