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. You can also submit new ideas or vote for other ideas via Microsoft Feedback. 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. Change the range the rule refers to in the rule manager.More coming soon to Conditional Formatting 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 – you can now specify the formatting criteria using a logical formula in Excel for the web.We have also added new rule types to Excel for the web, continuing to close the gap with desktop. Use the straightforward dropdowns to specify the criteria and choose a format. In the new rule editor, you will find the familiar rule types like those in Excel desktop. To add a new rule, click on the New Rule button in the side pane or use the Conditional Formatting menu in the ribbon. To edit a rule, click on the Edit button in the side pane. In addition to managing rules, you can also edit or add new ones in Excel for the web. You can manage the rules for the current selection or the entire sheet with simple dropdown. Simply hover the mouse pointer over a rule to see the range it refers to. With the new side pane, you can manage the rules while seeing the formatting result on the grid.

Tableedit app conditional formatting