Formatting Issues

Fix Incorrect Excel Conditional Formatting in Teams or SharePoint

Bushra Parveen Oct 7, 2026 870 views

Question details

User needs to resolve an issue where Excel conditional formatting rules work correctly in the desktop app but display incorrectly when viewed in Teams or Excel for the web.

Fix Incorrect Excel Conditional Formatting in Teams or SharePoint

Product: Microsoft Excel (Teams, SharePoint, Web)
Device & OS: not provided
Scenario: Viewing or editing shared Excel workbooks online that rely on date-based formulas or specific conditional formatting.
Observed behavior: Conditional formatting displays incorrectly or fails to trigger in the web or Teams environment, often due to mismatched regional date formats between the desktop and the SharePoint site.

Before you start

Ensure you have Site Owner or Administrator permissions in SharePoint to modify the regional and language settings for the connected site.

Solution 1Recommended

Align Regional Settings in Teams or SharePoint

Match the SharePoint site's regional settings to your desktop's local format to fix broken date-based conditional formatting.

SharePoint and Teams use their own site-level regional settings, which determine how dates and numbers are formatted in Excel for the web. If your desktop Excel uses US formats (mm/dd/yy) but the site uses UK formats (dd/mm/yy), date-based conditional formatting will evaluate incorrectly.

Access SharePoint Site Settings

Navigate to the SharePoint site connected to your Teams channel where the Excel file is stored, click the gear icon (Settings), and select 'Site information' followed by 'View all site settings'.

Modify Regional Settings

Under the 'Site Administration' section, click on 'Regional settings'.

Match Local Format

Change the 'Locale' dropdown to match the regional setting used on your local desktop (e.g., English (United States)) and click 'OK' to save.

Retest the Formatting

Refresh the Excel file in Teams or Excel for the web to verify that the conditional formatting rules now display correctly.

Align Regional Settings in Teams or SharePoint

Instant Update: Changes to regional settings typically take effect immediately upon refreshing the browser or Teams tab.

Solution 2

Reapply Conditional Formatting Rules in Excel for the Web

Force the web application to recognize and recalculate the formatting rules by editing them directly in the browser.

Free Microsoft Office alternative

Experience Seamless Spreadsheet Formatting with WPS Office

If you are tired of troubleshooting web-syncing glitches and regional formatting mismatches in Microsoft Excel and Teams, consider trying WPS Office. It provides a lightweight, easy-to-use, and highly compatible alternative that processes complex formatting flawlessly on your desktop.

1. Download WPS Office: Visit the official WPS website and download the free WPS Office suite for your operating system.
2. Install and Launch: Run the installer and launch the WPS Spreadsheet application.
3. Open Your Workbooks: Open your existing .xlsx files to edit them with all original conditional formatting perfectly preserved.

100% compatible with Microsoft Excel (.xlsx, .xls) file formatsRobust and reliable conditional formatting without web-sync issuesFree, lightweight application that loads quickly on any deviceFamiliar, tabbed user interface ensuring zero learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Why do date-based formulas break when uploaded to SharePoint?

SharePoint applies its own default regional settings to files viewed in the web environment. If these settings differ from the local desktop settings where the file was created (like switching days and months), Excel for the web misinterprets the date values, causing formulas and formatting to break.

Can I set Teams to automatically use my computer's local date format?

No, Excel files viewed within Teams rely on the underlying SharePoint site's regional settings. A SharePoint administrator must manually align the site's Locale settings with the users' preferred desktop format to resolve discrepancies.

Does WPS Office support complex conditional formatting?

Yes, WPS Spreadsheet fully supports advanced conditional formatting rules, including color scales, data bars, icon sets, and custom formula-based formatting. These rules are fully compatible and retain their visual behavior when switching between WPS Office and Microsoft Excel.

Document & File Issues