5

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.

1

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.

https://support.office.com/en-ie/article/

1

I have just been using an online Excel spreadsheet and it is now possible to setup conditional formatting in Online Excel.

Screen shot slice of online excel

  • Hi Martlark, thanks for your answer. Could you link to some documentation on this change in the body of your answer? – jonsca Mar 26 '19 at 0:38
0

It is not possible. Conditional formatting may be viewed but not applied in Excel Online.

  • 2
    Welcome 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. – jonsca Jul 18 '16 at 22:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.