New Conditional Formatting experience in Excel for the web
Published Jan 20 2022 06:45 AM 15.6K Views
Microsoft

Excel for the web has evolved into a full-featured modern spreadsheet app that can effectively support your daily work. Today, that experience continues to improve with the new Conditional Formatting capability, making it easier for you to manage, edit, and create formatting rules based on specific criteria, to help you quickly spot trends and insight from your data.

 

Manage rules in a new side pane 

With the new side pane, you can manage the rules while seeing the formatting result on the grid. Simply hover the mouse pointer over a rule to see the range it refers to. 

Manage rules in a new side paneManage rules in a new side pane

 

You can manage the rules for the current selection or the entire sheet with simple dropdown. 

Manage rules in sheet or selectionManage rules in sheet or selection

 

Edit rules or add new ones 

In addition to managing rules, you can also edit or add new ones in Excel for the web. 

To edit a rule, click on the Edit button in the side pane.  

Edit rulesEdit rules

 

To add a new rule, click on the New Rule button in the side pane or use the Conditional Formatting menu in the ribbon. 

Add new rulesAdd new rules

 

In the new rule editor, you will find the familiar rule types like those in Excel desktop. 

Rule typesRule types

 

Use the straightforward dropdowns to specify the criteria and choose a format. 

Formatting criteriaFormatting criteria

 

New rule types 

We have also added new rule types to Excel for the web, continuing to close the gap with desktop. 

  • Greater than or equals to 
  • Less than or equals to 
  • Not containing 
  • Beginning with 
  • Ending with 
  • Blanks/No blanks 
  • Errors/No errors 
  • Formula – you can now specify the formatting criteria using a logical formula in Excel for the web. This rule type gives you the added flexibility of formatting a range based on the result of a function or evaluate data in cells outside the selected range.

Formula rule typeFormula rule type

 

More coming soon to Conditional Formatting in Excel for the web: 

  • Reorder rules with drag & drop 
  • Change the range the rule refers to in the rule manager 
  • Custom formatting 

Your feedback is important for us! Tell us what you think about the new Conditional formatting experience in Excel for the web by writing a comment on this blog post or Send us a smile or frown. You can also submit new ideas or vote for other ideas via Microsoft Feedback. 

 

Want to know more about Excel for the web? See What's new in Excel for the web and subscribe to our Excel Blog to get the latest updates. Stay connected with us and other Excel fans around the world – join our Excel Community and follow us on Twitter. 

 

Thank you!

 

10 Comments
Co-Authors
Version history
Last update:
‎Jan 20 2022 06:43 AM
Updated by: