Others

How to Use JSON Formatting and Cell Comments in Microsoft Lists

Elise Williams Oct 23, 2026 870 views

Question details

The user wants to attach comments to individual cells in Microsoft Lists and use JSON formatting to apply conditional colors to specific numerical values.

How to Apply JSON Formatting and Handle Cell Comments in Microsoft Lists

Product: Microsoft Lists
Device & OS: not provided
Scenario: Managing list data where specific values require dynamic conditional coloring and users need to leave comments on distinct data cells.
Observed behavior: Microsoft Lists does not support direct cell-level comments, and conditional styling requires custom JSON column formatting.

Before you start

Before customizing your list, ensure you have the appropriate Edit or Owner permissions for the Microsoft Lists or SharePoint site to apply advanced column formatting.

Solution 1Recommended

Use JSON Formatting for Conditional Cell Colors

Apply custom JSON code to your list columns to dynamically change the text or background color based on the cell's value.

Microsoft Lists supports JSON formatting to customize how columns are displayed. This allows you to apply logical conditions, such as coloring specific numbers red or blue.

Open Column Settings

Navigate to your Microsoft List, click on the header of the column you want to format, and select 'Column settings' followed by 'Format this column'.

Enable Advanced Mode

In the format pane on the right side of the screen, click on 'Advanced mode' at the bottom to switch from the basic interface to the JSON code editor.

Apply JSON Code

Paste your custom JSON code that dictates the color conditions (e.g., displaying 575000 in red) into the editor box, and click 'Save' to apply the formatting to your list.

Use JSON Formatting for Conditional Cell Colors

Need advanced JSON assistance?: If you are unfamiliar with JSON syntax, it is highly recommended to post your specific formatting requirements on the Microsoft Q&A forum for expert developer assistance.

Solution 2

Workarounds for Cell-Level Comments

Since direct cell comments are currently unsupported in Microsoft Lists, utilize native list comments or a dedicated text column.

Free Microsoft Office alternative

Manage Data and Cell Comments Easily with WPS Office

If Microsoft Lists feels too complex for simple data tracking or lacks spreadsheet features like native cell comments, try WPS Spreadsheet. It offers a lightweight, easy-to-use interface where conditional formatting and cell-level comments require zero coding.

1. Export and Import Data: Export your Microsoft Lists data to an Excel file and open it directly in WPS Spreadsheet without losing any formatting.
2. Add Native Cell Comments: Right-click on any specific cell in your dataset and select 'Insert Comment' to easily add contextual notes.
3. Apply Conditional Formatting: Highlight your data, click 'Conditional Formatting' from the Home tab, and set up color rules instantly without writing a single line of JSON code.

Free and lightweight alternative to Microsoft OfficeFully compatible with Microsoft Excel (.xlsx) formatsNative support for cell-level comments and simple conditional formattingFamiliar user interface with zero learning curve for seamless migration

microsoft office alternative - wps office

Frequently Asked Questions

Can I add a comment to a specific cell in Microsoft Lists?

No, Microsoft Lists currently only supports comments at the list item (row) level. To leave a note for a specific data point, you must create a separate 'Multiple lines of text' column as a workaround.

Where can I get help writing custom JSON code for Microsoft Lists?

For advanced JSON column or view formatting, it is best to post your requirements on the Microsoft Q&A forum. The community there specializes in developer-level support for SharePoint and Microsoft 365 products.

How do I change row colors based on a column value without using JSON?

Microsoft Lists provides basic conditional formatting out of the box. Click on your column header, select 'Column settings', choose 'Format this column', and use the 'Conditional formatting' rules builder to set background colors using a visual interface instead of code.

Office Quick Solutions