List Conditional Field Resolution For Free

Here's how. In the Home tab of your ribbon, click Conditional Formatting. Then select Manage Rules. In the Conditional Formatting panel that appears, click the New Rule icon, which looks like a plus sign ( + ). In the Apply to range field, input your range. Click Done.

To format a column, click on a drop-down next to the column you want to format/color-code, then Columns Settings > Format this column. You may have up to 3 choices available (depends on the type of column you are formatting).

Go to the list or library where you want to show or hide columns. , then select Column Settings > Show/hide columns. In the Edit view columns pane, check (to show) or uncheck (to hide) the box for the column or columns as needed.

At the top of the form, select Edit form > Edit columns. In the Edit columns pane, check (to show) or uncheck (to hide) the checkbox for the column or columns as needed.

In your list or library, select the column header for the column you want to customize. (In this example, we use Name column). Select Column settings, then select Format this column. Under Format column, select Conditional formatting, then select Manage rules.

Conditional formatting Select Manage Rules > + Add rule. Choose a column to base the rule on. Choose a comparison: either is equal to or is not equal to. Type a value to compare the chosen column to. Select the edit icon to change the appearance of items affected by the rule.

To open the Format column panel, select a column heading, select Column settings from the menu, and then select Format this column. The Format column panel appears. Copy and paste text from the column formatting JSON reference to columns in your SharePoint list.