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.
Add a comment
|
4 Answers
I have just been using an online Excel spreadsheet and it is now possible to setup conditional formatting in Online Excel.
-
Hi Martlark, thanks for your answer. Could you link to some documentation on this change in the body of your answer?– jonscaMar 26, 2019 at 0:38
Support: YES
Set up: NO
Edit: NO
Support: YES
Set up: NO
Edit: NOExcel 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.
It is not possible. Conditional formatting may be viewed but not applied in Excel Online.
-
2Welcome to Web Applications Stack Exchange! While this may answer the question, it would be preferable to include the essential parts of the answer here and provide the link for reference.– jonscaJul 18, 2016 at 22:18
It does. If your browser is shown on a big screen, it is directly in the ribbon’s Home tab:
If you are using a smaller screen, it is hidden under the Tables category in the Home tab:
The blog post “Excel for the Web” posted on 2020-07-15 documents that this feature was added to “Excel for Web” (Excel Online) in the first half of 2020. The support article “What's new in Excel for the web” in section “Released in 2020” lists this feature.
