Add the "Manage Rules" Function in Conditional Formatting for Excel Online.
Now that conditional formatting is available in Excel Online, there is no way to view or edit the rules that are already in effect. Normally (offline) you can highlight a range of cells and then select "Manage Rules" from the Conditional Formatting drop down menu. As it is right now you can only clear all the rules or add new rules, but there is no way to modify existing rules or view the formulas for existing rules. This is very frustrating!
Danika Setaro
shared this idea
39 comments
-
Nick
commented
Looks like this has now been implemented.
-
Anonymous
commented
MS is so slow to respond to UI deficiencies.
Minimum Viable Products. Definitely not Minimum Lovable Products. -
Chris Beckett
commented
Until MS can replicate existing functionality they should not publish this as a working product
-
Anonymous
commented
We can add this to the litany of reduced functionality that Office online gives us. I spent ages creating conditional formats, but when I shared it with colleagues the sheet does not display any of my formats in the online version. Just like in Word, where the text wrap options for in-line graphics are much reduced, we are being sold a lesser product. I am still having to keep desktop versions of Office running, and we cant and wont fully migrate to On line. Indeed, we migrate away from Office completely!
-
Anonymous
commented
Not much to add really that hasn't already been said. It is truly rubbish Microsoft, Google Sheets is far superior in every way.
-
jenna
commented
well... I tried to use you microsoft 365...but this is a serious handicap and It doesn't appear to be one that's gonna get fixed anytime soon... I'm going back to google - that was a frustrating waste of a day!
-
[Deleted User]
commented
I can't ADD a rule, how dumb is that!
-
Anonymous
commented
I was so relieved when I saw that excel was online so I could finally recreate a teaching method for heat transfer that relies on conditional formatting. But it looks like they didn't make it accessible to excel and two years later they've done nothing for it...I guess this project is out the window...
-
Ingemar Gerbro
commented
Viktig och mycket praktisk funktion som saknas.
-
Anonymous
commented
Why are the online versions of Microsoft office apps so limited? We just switched from Google sheets and docs, and I feel like I am totally hobbled. Cannot edit conditional formatting rules - have to clear them and start over, cannot select anything but 5 preset color combos. Forms to Excel is cludgy (adds unwanted columns you cannot remove, cannot edit form and rearrange columns, etc.) Really? Microsoft, please play around with Google's version of online apps and then upgrade yours accordingly.
-
Marty
commented
Is there a plan to remedy this?
-
Anonymous
commented
So, I thought I was crazy and missing something. Now I know it's not my problem...but it's a MAJOR PROBLEM!! UGH!!!!!!
-
Sumer Singh
commented
We really need to have this feature in online excel, its really weird we cannot change or manage rules and only fixed colors
-
Anonymous
commented
This feature is really not available ? How ? This is a must have feature, I see no reason not to add this menu. Pls
-
Sine
commented
I agree. This is terrible. Makes me want to go back to Google Docs asap. I can't even create a new custom rule. All I can do is clear rules. The existing rules that I already had worked, but there is no way to edit those or add any new ones.
-
Anonymous
commented
Why is this not in place? It is really important!
-
Anonymous
commented
i am going back to google sheets..... Thanks Microsoft.
-
mark
commented
why why why ???
where is the response from Microsoft? you have literally neutered one of the most useful things in Excel -
Meaghan Fox
commented
I had to Open in Desktop App, edit there, save and then it reflected in Excel Online.
-
mark
commented
hello microsoft? why ain't you adding this basic function