Excel Online Conditional Formatting - Unable to Edit Existing Rules

%3CLINGO-SUB%20id%3D%22lingo-sub-2196368%22%20slang%3D%22en-US%22%3EExcel%20Online%20Conditional%20Formating%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2196368%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20have%20a%20file%20that%20was%20originally%20created%20in%20Excel%20Desktop.%20We%20are%20wishing%20to%20move%20the%20file%20to%20%3CU%3Eonly%3C%2FU%3E%20online%20to%20prevent%20change%2Fversion%20errors.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20conditional%20formats%20that%20were%20created%20on%20desktop%20work%20after%20the%20upload%20to%20Excel%20Online.%3C%2FP%3E%3CP%3EOnce%20in%20Excel%20Online%20I%20can%20go%20to%20Conditional%26gt%3BManage%20Rules%20%26gt%3B%20which%20then%20opens%20the%20current%20rules%20in%20a%20right%20side%20bar.%3C%2FP%3E%3CP%3EThe%20problems%20is%20I%20can't%20click%20on%20them%20to%20Manage%2Fedit%20them.%20The%20only%20option%20that%20appears%20is%20to%20Trash%20them.%3C%2FP%3E%3CP%3EPlease%20tell%20l%20me%20that%20there%20is%20a%20way%20to%20actually%20edit%20them%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20also%20do%20not%20see%20New%20Rule.%3C%2FP%3E%3CP%3EDoes%20this%20mean%20that%20I%20can%20not%20even%20create%20a%20new%20custom%20Conditional%20Format%20with%20a%20custom%20color%20online%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESidebar%3A%20If%20neither%20of%20these%20are%20possible%2C%20I%20honestly%20don't%20understand%20how%20MS%20is%20competing%20with%20Google%20Docs.%20I%20just%20double%20checked%20after%20uploading%20the%20same%20file%20to%20Sheets%20and%20I%20can%20both%20edit%20the%20exiting%20conditional%20rules%20and%20create%20a%20new%20one%20with%20a%20custom%20color%2C%20not%20just%20Red%2C%20Yellow%20Green.%3C%2FP%3E%3CP%3EI%20really%20hope%20it's%20User%20Error%20and%20I'm%20doing%20something%20wrong.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2196368%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2196447%22%20slang%3D%22en-US%22%3EBetreff%3A%20Excel%20Online%20Conditional%20Formating%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2196447%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F991992%22%20target%3D%22_blank%22%3E%40MarcusAD1979%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice365%2Fservicedescriptions%2Foffice-online-service-description%2Fexcel-online%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EExcel%20for%20Web%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice365%2Fservicedescriptions%2Foffice-online-service-description%2Foffice-online-service-description%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%3CSPAN%3EOffice%20for%20the%20web%20service%20description%3C%2FSPAN%3E%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EExcel%20for%20the%20web%20(formerly%20Excel%20Web%20App)%20extends%20your%20Microsoft%20Excel%20experience%20to%20the%20web%20browser%2C%20where%20you%20can%20work%20with%20workbooks%20directly%20on%20the%20website%20where%20the%20workbook%20is%20stored.%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EAll%20customers%20can%20view%20and%20lightly%20edit%20Office%20files%20using%20Office%20for%20the%20web.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3EOffice%20for%20the%20web%2C%20for%20a%20program%20that%20is%20%22free%22%2C%20it%20can%20do%20a%20lot%20more%20than%20it%20costs.%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3EI%20can't%20compare%20it%20to%20Google%20sheets%2C%20Excel%20for%20web%20is%20a%20software%20pumped%20full%20of%20steroids%20%3A)).%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3EIt's%20like%20comparing%20a%20booster%20to%20a%20hand-operated%20machine%20%3A)).%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3EExcel%20is%20the%20most%20beautiful%20invention%20for%20me...%20since%20chocolate%20has%20existed%20%3A)).%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3EPS.%20I%20am%20in%20no%20way%20affiliated%20with%20Microsoft%2C%20directly%20or%20indirectly%20in%20any%20form.%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20I%20was%20able%20to%20help%20you%20with%20the%20info%2Flink.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2196526%22%20slang%3D%22en-US%22%3EBetreff%3A%20Excel%20Online%20Conditional%20Formating%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2196526%22%20slang%3D%22en-US%22%3E%3CP%3ENikolino%2C%3CBR%20%2F%3EI%20love%20Excel%20as%20well%20and%20prefer%20it%20which%20is%20why%20I%20choose%20to%20move%20this%20file%20to%20Excel%20Online%20instead%20of%20Google%20Sheets.%20But%20if%20the%20same%20file%20has%20more%20functionality%20on%20Google%20Sheets%2C%20I%20will%20likely%20have%20to%20move%20it%20there.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20don't%20see%20how%20Google%20Sheets%20is%20providing%20two%20functions%20that%20MS%20Excel%20for%20the%20web%20is%20not%2C%20for%20the%20same%20price%2C%20Free.%3CBR%20%2F%3E%3CBR%20%2F%3EAnd%20honestly%20I%20don't%20see%20Excel%20online%20as%20being%20fully%20free%20for%20those%20that%20already%20own%20desktop%20copies%20of%20MS%20Office.%20The%20main%20problem%20I%20see%20with%20this%20is%20that%20people%20who%20use%20MS%20Excel%2C%20and%20pay%20for%20it%2C%20should%20not%20have%20less%20functionality%20than%20people%20who%20use%20Google%20Sheets%20when%20they%20wish%20to%20have%20a%20file%20on%20the%20cloud.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2309261%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Online%20Conditional%20Formatting%20-%20Unable%20to%20Edit%20Existing%20Rules%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2309261%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F991992%22%20target%3D%22_blank%22%3E%40MarcusAD1979%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3EHi%20I%20can%20confirm%20it%20is%20some%20type%20of%20bug.%26nbsp%3B%3CBR%20%2F%3EI%20can%20see%20edit%20in%20some%20documents%20but%20other%20users%20can%20not.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EStill%20trying%20to%20figure%20out%20how%20to%20fix%20this.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2309948%22%20slang%3D%22de-DE%22%3ERe%3A%20Excel%20Online%20Conditional%20Formatting%20-%20Unable%20to%20Edit%20Existing%20Rules%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2309948%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F721005%22%20target%3D%22_blank%22%3E%40winters80%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CH2%20id%3D%22toc-hId--520465410%22%20id%3D%22toc-hId--520467394%22%20id%3D%22toc-hId--520468293%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel-blog%2Fbg-p%2FExcelBlog%22%20target%3D%22_self%22%3EExcel%20Blog%3C%2FA%3E%3C%2FH2%3E%3CP%3ESubscribe%20to%20the%20Excel%20Blog%20to%20get%20the%20latest%20product%20announcements%20and%20updates%3C%2FP%3E%3CP%3E--------------------------%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EAs%20far%20as%20I%20know%2C%20conditional%20formatting%20is%20not%20possible%20in%20Excel%20for%20web.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EYou%20can%20call%20this%2C%20but%20conditional%20formatting%20was%20not%20possible%20until%20recently.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EBut%20with%20Excel%20for%20web%2C%20panta%20rhei%20(ancient%20Greek%20%E1%BF%A5%CE%B5%E1%BF%96%2C%20everything%20flows%20').%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EToday%20it%20is%20not%20possible%2C%20tomorrow%20it%20will%20be%20different.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EIt%20evolves%20as%20does%20its%20users.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EIf%20you%20have%20problems%20with%20your%20Excel%20for%20web%2C%20or%20think%20that%20the%20software%20is%20not%20working%20correctly%2C%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EThis%20is%20the%20right%20place%20to%20have%20this%20confirmed%20or%20get%20tips%20on%20how%20to%20resolve%20the%20problem.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EIf%20I%20may%20recommend%20adding%20a%20file%20(without%20sensitive%20data)%20with%20your%20concerns%2C%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3Edescribe%20your%20concerns%20in%20detail%20on%20the%20basis%20of%20the%20file.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EA%20detailed%20description%20of%20the%20Excel%20version%20and%20the%20operating%20system%20are%20an%20advantage.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EThank%20you%20for%20your%20patience%20and%20understanding%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2310207%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Online%20Conditional%20Formatting%20-%20Unable%20to%20Edit%20Existing%20Rules%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2310207%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F721005%22%20target%3D%22_blank%22%3E%40winters80%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EManage%20rules%20now%20available%20in%20Excel%20Online%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20336px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F277011i89E03366FDD63383%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Ebut%20so%20far%20you%20can%20only%20check%20them%20and%20delete.%20Adding%20new%20rules%20and%20editing%20is%20coming.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi,

I have a file that was originally created in Excel Desktop. We are wishing to move the file to only online to prevent change/version errors.

 

The conditional formats that were created on desktop work after the upload to Excel Online.

Once in Excel Online I can go to Conditional>Manage Rules > which then opens the current rules in a right side bar.

The problems is I can't click on them to Manage/edit them. The only option that appears is to Trash them.

Please tell l me that there is a way to actually edit them?

 

I also do not see New Rule.

Does this mean that I can not even create a new custom Conditional Format with a custom color online?

 

 

Sidebar: If neither of these are possible, I honestly don't understand how MS is so behind Google Docs. I just double checked after uploading the same file to Sheets and I can both edit the exiting conditional rules and create a new one with a custom color, not just Red, Yellow Green.

I really hope it's User Error and I'm doing something wrong. 

 

 

7 Replies

@MarcusAD1979 

 

Excel for Web

 

Office for the web service description

Excel for the web (formerly Excel Web App) extends your Microsoft Excel experience to the web browser, where you can work with workbooks directly on the website where the workbook is stored.

All customers can view and lightly edit Office files using Office for the web.

 

Office for the web, for a program that is "free", it can do a lot more than it costs.

I can't compare it to Google sheets, Excel for web is a software pumped full of steroids :)).

It's like comparing a booster to a hand-operated machine :)).

 

Excel is the most beautiful invention for me... since chocolate has existed :)).

 

PS. I am in no way affiliated with Microsoft, directly or indirectly in any form.

 

Hope I was able to help you with the info/link.

 

Nikolino

I know I don't know anything (Socrates)

 

Nikolino,
I love Excel as well and prefer it which is why I choose to move this file to Excel Online instead of Google Sheets. But if the same file has more functionality on Google Sheets, I will likely have to move it there.

I don't see how Google Sheets is providing two functions that MS Excel for the web is not, for the same price, Free.

And honestly I don't see Excel online as being fully free for those that already own desktop copies of MS Office. The main problem I see with this is that people who use MS Excel, and pay for it, should not have less functionality than people who use Google Sheets when they wish to have a file on the cloud.

@MarcusAD1979 
Hi I can confirm it is some type of bug. 
I can see edit in some documents but other users can not. 

Still trying to figure out how to fix this.

@winters80 

Excel Blog

Subscribe to the Excel Blog to get the latest product announcements and updates

--------------------------

As far as I know, conditional formatting is not possible in Excel for web.

You can call this, but conditional formatting was not possible until recently.

But with Excel for web, panta rhei (ancient Greek πάντα ῥεῖ, everything flows ‘).

Today it is not possible, tomorrow it will be different.

It evolves as does its users.

If you have problems with your Excel for web, or think that the software is not working correctly,

this is the right place to have this confirmed or get tips on how to resolve the problem.

If I may recommend adding a file (without sensitive data) with your concerns,

describe your concerns in detail on the basis of the file.

A detailed description of the Excel version and the operating system are an advantage.

 

Thank you for your patience and understanding

 

Nikolino

I know I don't know anything (Socrates)

@winters80 

Manage rules now available in Excel Online

image.png

but so far you can only check them and delete. Adding new rules and editing is coming.

@Sergei Baklan 
Thank you.
However I am only talking about editing. I have one account that is SharePoint admin with site collection access, with this account I can edit the colours on the CF.
The second account has the same permission and to the file. With this account I can only delete the CF.

The file creator can only delete the CF and not set colours on CF.

Trying to find out why only one account can do this when all the rest has the same permissions. 

@winters80 

Usually people with same subscription in same tenant have same set of functionality except targeted users who receive new functionality first. If your first account is in targeted users list that's normal situation. If not I'd send a frown and/or open support ticket.