Apply or change conditional formatting

Excel Online supports Conditional Formatting with Data Bars, Color Scales and Icon Sets. Select a range to be formatted, and go to Home > Conditional Formatting > Pick your style. If you need to clear an existing format you can choose the Clear Rules option.

Conditional Formatting menu in Excel Online

If you want to apply other Conditional Formatting options, and have the Excel desktop application, you can use it to add and change conditional formatting. Here's how:

Click Edit in Excel and follow the steps in add or change conditional formatting.

After making changes and saving your workbook in Excel desktop application, you'll see the changes when you reopen it in Excel Online.

If you don't have the Excel desktop application, you can give it a try. Or, you can buy it here, when you're ready to switch.

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.