Let's say that we want to highlight all unit sales under 100 by changing the cell's background color to red. A rule in Excel Online works as an if this, then that statement. Just as it sounds, Excel's conditional formatting feature lets you dynamically change the format of a cell (the background or the text), based on the rules that you've set. Then log in to your OneDrive account, and you'll be able to manipulate the data from there. Open the spreadsheet in your browser, and select Save to OneDrive. Here, we'll walk through how to use conditional formatting in Excel Online. Simple things like bolding text and splitting up paragraphs goes a long way.īut what about when you're working in a spreadsheet? How can you highlight important or insightful sections of a large data set? How can you add visual flair to certain rows and columns that will not only make the spreadsheet more visually pleasing but also more useful? When you're writing a blog post, an email, or a Slack message, you use formatting to make it more readable.
