Others

How to Highlight an Entire SharePoint List Row Based on Cell Text

Maira Mehtab Oct 12, 2026 870 views

Question details

The user wants to apply conditional formatting to highlight an entire row in a SharePoint list when a specific column contains a certain text value, similar to how conditional formatting works in Excel.

How to Highlight an Entire SharePoint List Row Based on Cell Text

Product: Microsoft SharePoint
Device & OS: not provided
Scenario: Tracking event invitees or statuses where a confirmation update in one cell should visually highlight the entire corresponding row for better visibility.
Observed behavior: Standard SharePoint column conditional formatting only changes the background color of the individual cell instead of the entire row.

Before you start

Verify that you have Edit or Owner permissions for the SharePoint list, as customizing view formats requires adequate access rights. Also, identify the exact 'internal name' of the column you want to base the condition on.

Solution 1Recommended

Use Custom JSON View Formatting

Apply JSON code to your SharePoint List view settings to format entire rows based on the value of a specific column.

By default, SharePoint's built-in conditional formatting UI only applies to specific columns. To affect the entire row, you must switch to View Formatting and use a custom JSON script that references your target column's internal name.

Access view formatting

Navigate to your SharePoint list, click the View options dropdown menu (usually displaying your current view name like 'All Items' in the top right), and select 'Format current view'.

Switch to advanced mode

In the formatting pane that appears on the right side, click on 'Advanced mode' at the bottom to open the JSON editor.

Apply JSON code

Paste your custom JSON row formatting code into the text area. Ensure that the '$FieldName' variables in your JSON exactly match the internal names of your SharePoint columns.

Save and verify

Click 'Preview' to see if the entire row highlights based on your text criteria. If it works as expected, click 'Save' to apply the changes to all users.

Internal Name vs. Display Name: The internal column name is often different from the display name, especially if the column contained spaces when created. You can find the internal name by going to List Settings, clicking the column, and looking at the end of the page URL (Field=InternalName).

Solution 2

Request Custom Code on Microsoft Q&A

Seek expert help if you are unfamiliar with JSON syntax or if your conditional formatting logic is complex.

Free Microsoft Office alternative

Easily Highlight Rows and Manage Data with WPS Spreadsheet

While SharePoint lists require complex JSON coding for full-row formatting, managing your trackers and lists in a spreadsheet application offers a much simpler, code-free experience. WPS Office is a completely free, lightweight alternative to Microsoft Office that natively supports advanced conditional formatting for entire rows.

1. Open your data file: Launch WPS Spreadsheet and open the document containing your list or tracker.
2. Set up conditional formatting: Highlight your entire data range, then navigate to Home > Conditional Formatting > New Rule.
3. Apply a formula rule: Choose 'Use a formula to determine which cells to format', enter your condition (e.g., =$B2="Confirmed"), choose a fill color, and click OK.

Easily apply conditional formatting to entire rows without writing any JSON code100% compatible with Microsoft Excel (.xlsx) formats and featuresLightweight application with a familiar, user-friendly interfaceCompletely free alternative for all your office productivity needs

microsoft office alternative - wps office

Frequently Asked Questions

Can I use standard SharePoint tools to highlight an entire row without JSON?

No, the standard graphical interface for SharePoint column formatting typically only changes the appearance of the specific cell. To format the entire row based on a cell's value, you must use Advanced mode and apply custom JSON code.

How do I find the internal name of my SharePoint column?

Navigate to List Settings, click on the name of the column you want to check, and look at the URL in your web browser's address bar. The text immediately following 'Field=' at the very end of the URL is the internal column name.

Why is my SharePoint JSON row formatting not working?

JSON formatting is highly sensitive to syntax and exact naming. Ensure you are referencing the column's internal name (not the display name) using the correct format ([$InternalName]), and verify that your condition's text values match exactly, including casing and spacing.

Office Quick Solutions