Is it possible to set up conditional formats using Excel Online?
The cell's context menu doesn't have the option, and I can't find it in the ribbon either.
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this communityIs it possible to set up conditional formats using Excel Online?
The cell's context menu doesn't have the option, and I can't find it in the ribbon either.
Support: YES
Set up: NO
Edit: NO
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.
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.
After making changes and saving your workbook in Excel desktop application, you'll see the changes when you reopen it in Excel Online.
I have just been using an online Excel spreadsheet and it is now possible to setup conditional formatting in Online Excel.
It is not possible. Conditional formatting may be viewed but not applied in Excel Online.