New Conditional Formatting experience in Excel for the web

Published Jan 20 2022 06:45 AM 10.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!

 

5 Comments
%3CLINGO-SUB%20id%3D%22lingo-sub-3066188%22%20slang%3D%22en-US%22%3ENew%20Conditional%20Formatting%20experience%20in%20Excel%20for%20the%20web%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3066188%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22TextRun%20SCXW63878329%20BCX8%22%20data-contrast%3D%22none%22%3E%3CSPAN%20class%3D%22NormalTextRun%20CommentStart%20CommentHighlightPipeRest%20CommentHighlightRest%20SCXW63878329%20BCX8%22%20data-ccp-charstyle%3D%22normaltextrun%22%20data-ccp-charstyle-defn%3D%22%7B%26quot%3BObjectId%26quot%3B%3A%26quot%3B12c66006-1013-4f12-a9da-f2eb3a84c5fa%7C68%26quot%3B%2C%26quot%3BClassId%26quot%3B%3A1073872969%2C%26quot%3BProperties%26quot%3B%3A%5B469775450%2C%26quot%3Bnormaltextrun%26quot%3B%2C201340122%2C%26quot%3B1%26quot%3B%2C134233614%2C%26quot%3Btrue%26quot%3B%2C469778129%2C%26quot%3Bnormaltextrun%26quot%3B%2C335572020%2C%26quot%3B1%26quot%3B%2C469778324%2C%26quot%3BDefault%20Paragraph%20Font%26quot%3B%5D%7D%22%3EExcel%20for%20the%20web%20%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20CommentHighlightPipeRest%20SCXW63878329%20BCX8%22%20data-ccp-charstyle%3D%22normaltextrun%22%3Ehas%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW63878329%20BCX8%22%20data-ccp-charstyle%3D%22normaltextrun%22%3E%20evolved%20into%20a%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3CA%20class%3D%22Hyperlink%20SCXW63878329%20BCX8%22%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel-blog%2Fexcel-for-the-web-evolution-from-companion-app-to-collaboration%2Fba-p%2F2861998%22%20target%3D%22_blank%22%3E%3CSPAN%20class%3D%22TextRun%20Underlined%20SCXW63878329%20BCX8%22%20data-contrast%3D%22none%22%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW63878329%20BCX8%22%20data-ccp-charstyle%3D%22Hyperlink%22%3Efull-featured%20%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW63878329%20BCX8%22%20data-ccp-charstyle%3D%22Hyperlink%22%3Emodern%20%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW63878329%20BCX8%22%20data-ccp-charstyle%3D%22Hyperlink%22%3Es%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW63878329%20BCX8%22%20data-ccp-charstyle%3D%22Hyperlink%22%3Epreadsheet%20%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW63878329%20BCX8%22%20data-ccp-charstyle%3D%22Hyperlink%22%3Eapp%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20class%3D%22TextRun%20SCXW63878329%20BCX8%22%20data-contrast%3D%22none%22%3E%20%3CSPAN%20class%3D%22NormalTextRun%20SCXW63878329%20BCX8%22%3Ethat%20can%20effectively%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22TextRun%20SCXW63878329%20BCX8%22%20data-contrast%3D%22none%22%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW63878329%20BCX8%22%20data-ccp-charstyle%3D%22normaltextrun%22%3Esupport%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW63878329%20BCX8%22%20data-ccp-charstyle%3D%22normaltextrun%22%3E%20your%20daily%20work%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW63878329%20BCX8%22%20data-ccp-charstyle%3D%22normaltextrun%22%3E.%20Today%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW63878329%20BCX8%22%20data-ccp-charstyle%3D%22normaltextrun%22%3E%2C%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22NormalTextRun%20SCXW63878329%20BCX8%22%20data-ccp-charstyle%3D%22normaltextrun%22%3Ethat%20experience%20%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW63878329%20BCX8%22%20data-ccp-charstyle%3D%22normaltextrun%22%3Econtinues%20to%20%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW63878329%20BCX8%22%20data-ccp-charstyle%3D%22normaltextrun%22%3Ei%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW63878329%20BCX8%22%20data-ccp-charstyle%3D%22normaltextrun%22%3Emprove%20%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW63878329%20BCX8%22%20data-ccp-charstyle%3D%22normaltextrun%22%3Ewith%20the%20%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW63878329%20BCX8%22%20data-ccp-charstyle%3D%22normaltextrun%22%3Enew%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW63878329%20BCX8%22%20data-ccp-charstyle%3D%22normaltextrun%22%3E%20Conditional%20Formatting%20%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW63878329%20BCX8%22%20data-ccp-charstyle%3D%22normaltextrun%22%3Ecapability%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW63878329%20BCX8%22%20data-ccp-charstyle%3D%22normaltextrun%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW63878329%20BCX8%22%20data-ccp-charstyle%3D%22normaltextrun%22%3E%20making%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22NormalTextRun%20SCXW63878329%20BCX8%22%20data-ccp-charstyle%3D%22normaltextrun%22%3Eit%20easier%20%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW63878329%20BCX8%22%20data-ccp-charstyle%3D%22normaltextrun%22%3Efor%20you%20%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW63878329%20BCX8%22%20data-ccp-charstyle%3D%22normaltextrun%22%3Eto%E2%80%AFmanage%2C%20%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW63878329%20BCX8%22%20data-ccp-charstyle%3D%22normaltextrun%22%3Eedit%2C%20and%20%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW63878329%20BCX8%22%20data-ccp-charstyle%3D%22normaltextrun%22%3Ecreate%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22NormalTextRun%20SCXW63878329%20BCX8%22%20data-ccp-charstyle%3D%22normaltextrun%22%3Eformatting%20rules%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22NormalTextRun%20SCXW63878329%20BCX8%22%20data-ccp-charstyle%3D%22normaltextrun%22%3Ebased%20on%20specific%20criteria%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW63878329%20BCX8%22%20data-ccp-charstyle%3D%22normaltextrun%22%3E%2C%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22NormalTextRun%20SCXW63878329%20BCX8%22%20data-ccp-charstyle%3D%22normaltextrun%22%3Eto%20help%20you%20%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW63878329%20BCX8%22%20data-ccp-charstyle%3D%22normaltextrun%22%3Equickly%20%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW63878329%20BCX8%22%20data-ccp-charstyle%3D%22normaltextrun%22%3Espot%20trends%20and%20insight%20from%20your%20data.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3C%2FP%3E%3CDIV%20class%3D%22video-embed-center%20video-embed%22%3E%3CIFRAME%20class%3D%22embedly-embed%22%20src%3D%22https%3A%2F%2Fcdn.embedly.com%2Fwidgets%2Fmedia.html%3Fsrc%3Dhttps%253A%252F%252Fwww.youtube.com%252Fembed%252FX1QEXqSLjzo%253Ffeature%253Doembed%26amp%3Bdisplay_name%3DYouTube%26amp%3Burl%3Dhttps%253A%252F%252Fwww.youtube.com%252Fwatch%253Fv%253DX1QEXqSLjzo%26amp%3Bimage%3Dhttps%253A%252F%252Fi.ytimg.com%252Fvi%252FX1QEXqSLjzo%252Fhqdefault.jpg%26amp%3Bkey%3Db0d40caa4f094c68be7c29880b16f56e%26amp%3Btype%3Dtext%252Fhtml%26amp%3Bschema%3Dyoutube%22%20width%3D%22200%22%20height%3D%22112%22%20scrolling%3D%22no%22%20title%3D%22YouTube%20embed%22%20frameborder%3D%220%22%20allow%3D%22autoplay%3B%20fullscreen%22%20allowfullscreen%3D%22true%22%3E%3C%2FIFRAME%3E%3C%2FDIV%3E%3CP%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3E%3CSPAN%20data-contrast%3D%22none%22%3EManage%20rules%20in%20a%20new%20side%20pane%3C%2FSPAN%3E%3C%2FSTRONG%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3EWith%20the%20new%20side%20pane%2C%20you%20can%20manage%20the%20rules%20while%20seeing%20the%20formatting%20result%20on%20the%20grid.%20Simply%20hover%20the%20mouse%20pointer%20over%20a%20rule%20to%20see%20the%20range%20it%20refers%20to.%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Manage%20rules%20in%20a%20new%20side%20pane%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F340873iAC205BA4D55767D8%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%221_Rule%20manager.png%22%20alt%3D%22Manage%20rules%20in%20a%20new%20side%20pane%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EManage%20rules%20in%20a%20new%20side%20pane%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3EYou%20can%20manage%20the%20rules%20for%20the%20current%20selection%20or%20the%20entire%20sheet%20with%20simple%20dropdown.%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Manage%20rules%20in%20sheet%20or%20selection%22%20style%3D%22width%3A%20313px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F340874i192D9A891609CBAC%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%222_Manage%20rules%20in%20filter.png%22%20alt%3D%22Manage%20rules%20in%20sheet%20or%20selection%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EManage%20rules%20in%20sheet%20or%20selection%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3E%3CSPAN%20data-contrast%3D%22none%22%3EEdit%20rules%20or%20add%20new%20ones%3C%2FSPAN%3E%3C%2FSTRONG%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3EIn%20addition%20to%20managing%20rules%2C%20you%20can%20also%20edit%20or%20add%20new%20ones%20in%20Excel%20for%20the%20web.%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3ETo%20edit%20a%20rule%2C%E2%80%AFclick%20on%20the%20%3C%2FSPAN%3E%3CSTRONG%3E%3CSPAN%20data-contrast%3D%22none%22%3EEdit%3C%2FSPAN%3E%3C%2FSTRONG%3E%3CSPAN%20data-contrast%3D%22none%22%3E%20button%20in%20the%20side%20pane.%E2%80%AF%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Edit%20rules%22%20style%3D%22width%3A%20307px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F340875i2090BC9CFA17E694%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%223_Edit%20rule.png%22%20alt%3D%22Edit%20rules%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EEdit%20rules%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3ETo%20add%20a%20new%20rule%2C%20click%20on%20the%20%3C%2FSPAN%3E%3CSTRONG%3E%3CSPAN%20data-contrast%3D%22none%22%3ENew%20Rule%3C%2FSPAN%3E%3C%2FSTRONG%3E%3CSPAN%20data-contrast%3D%22none%22%3E%E2%80%AFbutton%20in%20the%E2%80%AFside%20pane%20or%20use%20the%20%3C%2FSPAN%3E%3CSTRONG%3E%3CSPAN%20data-contrast%3D%22none%22%3EConditional%20Formatting%3C%2FSPAN%3E%3C%2FSTRONG%3E%3CSPAN%20data-contrast%3D%22none%22%3E%E2%80%AFmenu%20in%20the%20ribbon.%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Add%20new%20rules%22%20style%3D%22width%3A%20309px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F340876iA76CEE0D51D1FC1C%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%224_Add%20rule.png%22%20alt%3D%22Add%20new%20rules%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EAdd%20new%20rules%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3EIn%20the%20new%20rule%20editor%2C%20you%20will%20find%20the%20familiar%20rule%20types%20like%20those%20in%20Excel%20desktop.%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Rule%20types%22%20style%3D%22width%3A%20317px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F340877iA80379E99F27A40C%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%225_Rule%20types.png%22%20alt%3D%22Rule%20types%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3ERule%20types%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3EUse%20the%20straightforward%20dropdowns%20to%20specify%20the%20criteria%20and%20choose%20a%20format.%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Formatting%20criteria%22%20style%3D%22width%3A%20229px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F340878i34EE6521670280AC%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%226_Formatting.png%22%20alt%3D%22Formatting%20criteria%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EFormatting%20criteria%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3E%3CSPAN%20data-contrast%3D%22none%22%3ENew%20rule%20types%3C%2FSPAN%3E%3C%2FSTRONG%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3EWe%20have%20also%20added%20new%20rule%20types%20to%20Excel%20for%20the%20web%2C%20continuing%20to%20close%20the%20gap%20with%20desktop.%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%20data-leveltext%3D%22%EF%82%B7%22%20data-font%3D%22Symbol%22%20data-listid%3D%224%22%20aria-setsize%3D%22-1%22%20data-aria-posinset%3D%221%22%20data-aria-level%3D%221%22%3E%3CSPAN%20data-contrast%3D%22none%22%3EGreater%20than%20or%20equals%20to%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335551550%26quot%3B%3A1%2C%26quot%3B335551620%26quot%3B%3A1%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%20data-leveltext%3D%22%EF%82%B7%22%20data-font%3D%22Symbol%22%20data-listid%3D%224%22%20aria-setsize%3D%22-1%22%20data-aria-posinset%3D%222%22%20data-aria-level%3D%221%22%3E%3CSPAN%20data-contrast%3D%22none%22%3ELess%20than%20or%20equals%20to%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335551550%26quot%3B%3A1%2C%26quot%3B335551620%26quot%3B%3A1%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%20data-leveltext%3D%22%EF%82%B7%22%20data-font%3D%22Symbol%22%20data-listid%3D%224%22%20aria-setsize%3D%22-1%22%20data-aria-posinset%3D%223%22%20data-aria-level%3D%221%22%3E%3CSPAN%20data-contrast%3D%22none%22%3ENot%20containing%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335551550%26quot%3B%3A1%2C%26quot%3B335551620%26quot%3B%3A1%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%20data-leveltext%3D%22%EF%82%B7%22%20data-font%3D%22Symbol%22%20data-listid%3D%224%22%20aria-setsize%3D%22-1%22%20data-aria-posinset%3D%223%22%20data-aria-level%3D%221%22%3E%3CSPAN%20data-contrast%3D%22none%22%3EBeginning%20with%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335551550%26quot%3B%3A1%2C%26quot%3B335551620%26quot%3B%3A1%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%20data-leveltext%3D%22%EF%82%B7%22%20data-font%3D%22Symbol%22%20data-listid%3D%224%22%20aria-setsize%3D%22-1%22%20data-aria-posinset%3D%223%22%20data-aria-level%3D%221%22%3E%3CSPAN%20data-contrast%3D%22none%22%3EEnding%20with%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335551550%26quot%3B%3A1%2C%26quot%3B335551620%26quot%3B%3A1%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%20data-leveltext%3D%22%EF%82%B7%22%20data-font%3D%22Symbol%22%20data-listid%3D%224%22%20aria-setsize%3D%22-1%22%20data-aria-posinset%3D%223%22%20data-aria-level%3D%221%22%3E%3CSPAN%20data-contrast%3D%22none%22%3EBlanks%2FNo%20blanks%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335551550%26quot%3B%3A1%2C%26quot%3B335551620%26quot%3B%3A1%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%20data-leveltext%3D%22%EF%82%B7%22%20data-font%3D%22Symbol%22%20data-listid%3D%224%22%20aria-setsize%3D%22-1%22%20data-aria-posinset%3D%223%22%20data-aria-level%3D%221%22%3E%3CSPAN%20data-contrast%3D%22none%22%3EErrors%2FNo%20errors%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335551550%26quot%3B%3A1%2C%26quot%3B335551620%26quot%3B%3A1%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%20data-leveltext%3D%22%EF%82%B7%22%20data-font%3D%22Symbol%22%20data-listid%3D%224%22%20aria-setsize%3D%22-1%22%20data-aria-posinset%3D%223%22%20data-aria-level%3D%221%22%3E%3CSPAN%20data-contrast%3D%22none%22%3EFormula%20%E2%80%93%20you%20can%20now%20specify%20the%20formatting%20criteria%20using%20a%20logical%20formula%20in%20Excel%20for%20the%20web.%20This%20rule%20type%20gives%20you%20the%20added%20flexibility%20of%20formatting%20a%20range%20based%20on%20the%20result%20of%20a%20function%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335551550%26quot%3B%3A1%2C%26quot%3B335551620%26quot%3B%3A1%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3Eor%20evaluate%20data%20in%20cells%20outside%20the%20selected%20range.%3C%2FSPAN%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Formula%20rule%20type%22%20style%3D%22width%3A%20319px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F340879i8CBC1FE2F44570C0%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%227_Formula%20rule.png%22%20alt%3D%22Formula%20rule%20type%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EFormula%20rule%20type%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3EMore%20coming%20soon%20to%20Conditional%20Formatting%20in%20Excel%20for%20the%20web%3A%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335551550%26quot%3B%3A1%2C%26quot%3B335551620%26quot%3B%3A1%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A216%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%20data-leveltext%3D%22%EF%82%B7%22%20data-font%3D%22Symbol%22%20data-listid%3D%226%22%20aria-setsize%3D%22-1%22%20data-aria-posinset%3D%221%22%20data-aria-level%3D%221%22%3E%3CSPAN%20data-contrast%3D%22none%22%3EReorder%20rules%20with%20drag%20%26amp%3B%20drop%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335551550%26quot%3B%3A1%2C%26quot%3B335551620%26quot%3B%3A1%2C%26quot%3B335559737%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%20data-leveltext%3D%22%EF%82%B7%22%20data-font%3D%22Symbol%22%20data-listid%3D%226%22%20aria-setsize%3D%22-1%22%20data-aria-posinset%3D%222%22%20data-aria-level%3D%221%22%3E%3CSPAN%20data-contrast%3D%22none%22%3EChange%20the%20range%20the%20rule%20refers%20to%20in%20the%20rule%20manager%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335551550%26quot%3B%3A1%2C%26quot%3B335551620%26quot%3B%3A1%2C%26quot%3B335559737%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%20data-leveltext%3D%22%EF%82%B7%22%20data-font%3D%22Symbol%22%20data-listid%3D%226%22%20aria-setsize%3D%22-1%22%20data-aria-posinset%3D%223%22%20data-aria-level%3D%221%22%3E%3CSPAN%20data-contrast%3D%22none%22%3ECustom%20formatting%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335551550%26quot%3B%3A1%2C%26quot%3B335551620%26quot%3B%3A1%2C%26quot%3B335559737%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3EYour%20feedback%20is%20important%20for%20us!%20Tell%20us%20what%20you%20think%20about%20the%20new%20Conditional%20formatting%20experience%20in%20Excel%20for%20the%20web%20by%20writing%20a%20comment%20on%20this%20blog%20post%20or%20%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fhow-do-i-give-feedback-on-microsoft-office-2b102d44-b43f-4dd2-9ff4-23cf144cfb11%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3ESend%20us%20a%20smile%20or%20frown.%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3BYou%20can%20also%20submit%20new%20ideas%20or%20vote%20for%20other%20ideas%20via%20%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Ffeedbackportal.microsoft.com%252Ffeedback%252Fforum%252Fc23f3b77-f01b-ec11-b6e7-0022481f8472%26amp%3Bdata%3D04%257C01%257CCuong.Pham%2540microsoft.com%257C24462222b3ac45e18c8408d9d14c8064%257C72f988bf86f141af91ab2d7cd011db47%257C0%257C0%257C637770948771666865%257CUnknown%257CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%253D%257C3000%26amp%3Bsdata%3DmL%252B1tuCsMypotthguCvWFzZi9xY39FQ3dxCoz4FO3Ho%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3EMicrosoft%20Feedback%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-contrast%3D%22none%22%3E.%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%3CSPAN%20class%3D%22TextRun%20SCXW60109839%20BCX8%22%20data-contrast%3D%22none%22%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW60109839%20BCX8%22%3EWant%20to%20know%20more%20about%20Excel%20for%20the%20web%3F%20See%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3CA%20class%3D%22Hyperlink%20SCXW60109839%20BCX8%22%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fwhat-s-new-in-excel-for-the-web-f8f98d6b-4752-4119-a2aa-4de22ece8d81%3Fns%3Dxlwaenduser%26amp%3Bversion%3D16%26amp%3Bui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%22%20target%3D%22_blank%22%20rel%3D%22noreferrer%20noopener%22%3E%3CSPAN%20class%3D%22TextRun%20Underlined%20SCXW60109839%20BCX8%22%20data-contrast%3D%22none%22%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW60109839%20BCX8%22%20data-ccp-charstyle%3D%22Hyperlink%22%3EWhat's%20new%20in%20Excel%20for%20the%20web%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20class%3D%22TextRun%20SCXW60109839%20BCX8%22%20data-contrast%3D%22none%22%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW60109839%20BCX8%22%3E%20and%20subscribe%20to%20%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20ContextualSpellingAndGrammarErrorV2%20SCXW60109839%20BCX8%22%3Eour%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3CA%20class%3D%22Hyperlink%20SCXW60109839%20BCX8%22%20href%3D%22https%3A%2F%2Faka.ms%2Fxlblog%22%20target%3D%22_blank%22%20rel%3D%22noreferrer%20noopener%22%3E%3CSPAN%20class%3D%22TextRun%20Underlined%20SCXW60109839%20BCX8%22%20data-contrast%3D%22none%22%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW60109839%20BCX8%22%20data-ccp-charstyle%3D%22Hyperlink%22%3EExcel%20Blog%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20class%3D%22TextRun%20SCXW60109839%20BCX8%22%20data-contrast%3D%22none%22%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW60109839%20BCX8%22%3E%20to%20get%20the%20latest%20updates.%20Stay%20connected%20with%20us%20and%20other%20Excel%20fans%20around%20the%20world%20%E2%80%93%20join%20%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20ContextualSpellingAndGrammarErrorV2%20SCXW60109839%20BCX8%22%3Eour%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3CA%20class%3D%22Hyperlink%20SCXW60109839%20BCX8%22%20href%3D%22https%3A%2F%2Faka.ms%2FExcelCommunity%22%20target%3D%22_blank%22%20rel%3D%22noreferrer%20noopener%22%3E%3CSPAN%20class%3D%22TextRun%20Underlined%20SCXW60109839%20BCX8%22%20data-contrast%3D%22none%22%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW60109839%20BCX8%22%20data-ccp-charstyle%3D%22Hyperlink%22%3EExcel%20Community%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20class%3D%22TextRun%20SCXW60109839%20BCX8%22%20data-contrast%3D%22none%22%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW60109839%20BCX8%22%3E%20and%20follow%20us%20on%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3CA%20class%3D%22Hyperlink%20SCXW60109839%20BCX8%22%20href%3D%22https%3A%2F%2Ftwitter.com%2Fmsexcel%22%20target%3D%22_blank%22%20rel%3D%22noreferrer%20noopener%20nofollow%22%3E%3CSPAN%20class%3D%22TextRun%20Underlined%20SCXW60109839%20BCX8%22%20data-contrast%3D%22none%22%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW60109839%20BCX8%22%20data-ccp-charstyle%3D%22Hyperlink%22%3ETwitter%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20class%3D%22TextRun%20SCXW60109839%20BCX8%22%20data-contrast%3D%22none%22%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW60109839%20BCX8%22%3E.%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22EOP%20SCXW60109839%20BCX8%22%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335551550%26quot%3B%3A6%2C%26quot%3B335551620%26quot%3B%3A6%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%3CSPAN%20class%3D%22EOP%20SCXW60109839%20BCX8%22%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335551550%26quot%3B%3A6%2C%26quot%3B335551620%26quot%3B%3A6%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3EThank%20you!%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-3066188%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22TextRun%20SCXW22576003%20BCX8%22%20data-contrast%3D%22none%22%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW22576003%20BCX8%22%20data-ccp-charstyle%3D%22normaltextrun%22%20data-ccp-charstyle-defn%3D%22%7B%26quot%3BObjectId%26quot%3B%3A%26quot%3B12c66006-1013-4f12-a9da-f2eb3a84c5fa%7C68%26quot%3B%2C%26quot%3BClassId%26quot%3B%3A1073872969%2C%26quot%3BProperties%26quot%3B%3A%5B469775450%2C%26quot%3Bnormaltextrun%26quot%3B%2C201340122%2C%26quot%3B1%26quot%3B%2C134233614%2C%26quot%3Btrue%26quot%3B%2C469778129%2C%26quot%3Bnormaltextrun%26quot%3B%2C335572020%2C%26quot%3B1%26quot%3B%2C469778324%2C%26quot%3BDefault%20Paragraph%20Font%26quot%3B%5D%7D%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Traser%20option_1.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F340792iE132DD5D47A2E0A1%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Traser%20option_1.png%22%20alt%3D%22Traser%20option_1.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22TextRun%20SCXW22576003%20BCX8%22%20data-contrast%3D%22none%22%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW22576003%20BCX8%22%20data-ccp-charstyle%3D%22normaltextrun%22%20data-ccp-charstyle-defn%3D%22%7B%26quot%3BObjectId%26quot%3B%3A%26quot%3B12c66006-1013-4f12-a9da-f2eb3a84c5fa%7C68%26quot%3B%2C%26quot%3BClassId%26quot%3B%3A1073872969%2C%26quot%3BProperties%26quot%3B%3A%5B469775450%2C%26quot%3Bnormaltextrun%26quot%3B%2C201340122%2C%26quot%3B1%26quot%3B%2C134233614%2C%26quot%3Btrue%26quot%3B%2C469778129%2C%26quot%3Bnormaltextrun%26quot%3B%2C335572020%2C%26quot%3B1%26quot%3B%2C469778324%2C%26quot%3BDefault%20Paragraph%20Font%26quot%3B%5D%7D%22%3ETry%20the%20new%20Conditional%20Formatting%20experience%20in%20Excel%20for%20the%20web%20today%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3066188%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20for%20the%20web%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3067431%22%20slang%3D%22en-US%22%3ERe%3A%20New%20Conditional%20Formatting%20experience%20in%20Excel%20for%20the%20web%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3067431%22%20slang%3D%22en-US%22%3E%3CP%3EGreat%20improvement.%20If%20only%20to%20add%20Duplicate%20Rule.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3068975%22%20slang%3D%22en-US%22%3ERe%3A%20New%20Conditional%20Formatting%20experience%20in%20Excel%20for%20the%20web%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3068975%22%20slang%3D%22en-US%22%3E%3CP%3EThat's%20great.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3069532%22%20slang%3D%22en-US%22%3ERe%3A%20New%20Conditional%20Formatting%20experience%20in%20Excel%20for%20the%20web%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3069532%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20interesting%20and%20new.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Co-Authors
Version history
Last update:
‎Jan 20 2022 06:43 AM
Updated by: