SharePoint Document Issues

How to Override SharePoint Column Formatting with View Formatting

Tauseeq Magsi Sep 25, 2026 869 views

Question details

The user wants to apply row-level view formatting in SharePoint that overrides the background colors and styles previously set by individual column formatting.

How to Override SharePoint Column Formatting with View Formatting

Product: Microsoft SharePoint
Device & OS: not provided
Scenario: Customizing the visual layout of a SharePoint list or document library using JSON view formatting.
Observed behavior: SharePoint view formatting correctly changes the row layout but fails to override the specific colors applied by existing column formatting.

Before you start

Before modifying list views, ensure you have the necessary Edit or Full Control permissions for the SharePoint list, and back up any existing JSON formatting code by copying it to a simple text editor.

Solution 1Recommended

Resolve Formatting Conflicts by Adjusting JSON Logic

Since SharePoint natively prioritizes column-level formatting over view-level formatting, you must manually remove or consolidate your JSON scripts to prevent color conflicts.

SharePoint Online has a known design limitation: view formatting (which targets entire rows) does not automatically override the specific colors or styles applied directly to individual columns using column formatting.

To achieve a unified row style, you cannot rely on a built-in override toggle. Instead, you need to remove the conflicting column-level JSON or integrate the logic directly into your view formatting script.

Locate the formatted column

Navigate to your SharePoint list, click the header of the column that currently has background colors applied, and select 'Column settings' followed by 'Format this column'.

Remove conflicting column JSON

In the formatting pane on the right, click 'Advanced mode' to view the JSON code. Delete or modify the JSON script responsible for the color overrides, then click 'Save'.

Apply styling via View Formatting

Click the view selector dropdown at the top right of the list (e.g., 'All Items'), select 'Format current view', and paste your consolidated row-level JSON code into the Advanced mode editor.

Resolve Formatting Conflicts by Adjusting JSON Logic

Need Advanced JSON Help?: For highly customized JSON development, it is recommended to consult the Microsoft Q&A community using the 'sharepoint-dev' or 'office-sharepoint-online' tags.

Free Microsoft Office alternative

Manage Your Exported SharePoint Data with WPS Office

While advanced SharePoint view formatting requires custom Microsoft JSON scripting, handling the actual data exported from your lists is incredibly easy with WPS Office. As a lightweight and free alternative to Microsoft Office, WPS Office offers perfect compatibility for your spreadsheets and documents.

1. Export your SharePoint list: In your SharePoint list, click 'Export' from the top command bar and select 'Export to Excel' to download your list data.
2. Open with WPS Spreadsheet: Launch WPS Office and open the downloaded .iqy or .xlsx file to instantly view and edit your data without formatting issues.
3. Save and share: Use WPS Office's advanced tools to create charts, apply local conditional formatting, and save your work locally or as a PDF.

Free and lightweight office suite for everyday document tasksFully compatible with Microsoft Excel (.xlsx) and Word (.docx) formats exported from SharePointFamiliar user interface ensuring zero learning curveBuilt-in PDF editing, conversion, and sharing tools

microsoft office alternative - wps office

Frequently Asked Questions

Why isn't my SharePoint view formatting applying to all columns?

If individual columns have their own JSON formatting applied, SharePoint prioritizes those column-level styles over the row-level (view) formatting. You must remove or alter the column formatting for the view formatting to take full effect.

Can I format a SharePoint list without using JSON?

Yes, SharePoint provides basic out-of-the-box formatting options via the user interface. You can set up alternating row colors or simple conditional formatting rules through the 'Format current view' menu without writing manual JSON code.

Where can I find official documentation on SharePoint view formatting?

You can review Microsoft's official declarative customization documentation online. If you need specific code solutions, the Microsoft Q&A platform (using tags like sharepoint-dev) is the best place to ask.

Document & File Issues