Create and edit custom Conditional Formatting rules
It would be really nice if we could create and edit custom rules for Conditional Formatting in Excel Online, similar to how we can in the Desktop version of Excel.
Thank you for your continued feedback and responses. We are glad to update that the work for this feature has started.
We’ll share more details as we progress.
Awesome! This is one of the remaining big reasons I prefer Google Sheets, glad to hear this feature is under development.
Katherine Onça Negra Kawula commented
it would be grest if it was not available only in Excel Online, but also on Android app. You have been promoting so much cooperation with Samsung and great is to use it on Samsung Tablets. Well, We have Galaxy Tab S7+ tablets and this is one of the most missing feature.
I can see that status has been changed to Planned on August 6th - it's been 6 months and nothing seem to have changed? So I guess its not going to be available sooner than 2022..
Ben Altman commented
I just did the same and it worked. It could be the latest version allows for it. I'd like to know how to do conditional formatting formulas from within Teams without having to use the Desktop version of Excel.
Marcelo Sauaf commented
Current "Manage rules" allow only to delete them, need to allow to edit.
Rob Weisberger commented
Here here!!! Or, at the very least, we should be able to edit what's already there. Not being able to see and edit what's there means you can't copy formatting and make small edits. You're starting from scratch in every cell.
Let us "Manage Rules."
Rob Weisberger commented
I just posted an excel file to Teams and the conditional formatting did not come with it. I haven't done any trouble shooting, but it appears that it's because I used formulas for the conditional formatting, rather than the other options.
Is there a reason you can't use formulas for conditional formatting on Teams?
Idontsay No commented
Sutee Apinun commented
cheer this idea !
Ingrid Sobieski commented
I would like to format a cell based on the content or formatting of another cell. This would become even more useful if I could apply the same formula to another cell and have the relational cell references remain the same.
Example: If $A1 contains "X", then I would like B1 to be filled red. I should be able to drag the formatting down the column so that all boxes in column B are formatted based on the content of their adjacent A cell.
I did my wedding invitation checklist this way using another online spreadsheet application and it was beautiful! I'd love to be able to do this with work matters since my company is a close friend to Microsoft!
Alex Green commented
Put in 'Add Rule' in Conditional Formatting
I'd like to be able to create my own conditional formatting and specify the colors that my team is used to at work. Having to open the workbook in Excel defeats the purpose of even having an online version.