Forum Discussion

MarcusAD1979's avatar
MarcusAD1979
Copper Contributor
Mar 09, 2021

Excel Online Conditional Formatting - Unable to Edit Existing Rules

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 desk...
excel
Excel for web
winters80's avatar
winters80
Copper Contributor
Apr 30, 2021

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.

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Apr 30, 2021

    winters80 

    Manage rules now available in Excel Online

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

    • Malleshg0072035's avatar
      Malleshg0072035
      Copper Contributor
      Aug 06, 2021
      Dear Sir,

      Please see the below table. 

      NAME COCACOLA HOSLICS ICE CREAM BISCUITS
      KADAPA 100 25 10 68
      HYDERABAD 41 53 57 94
      KARIMNAGAR 42 69 38 28
      VIJAYWADA 19 91 73 37

      I need to excel  formula is  below as per below table please confirm the same.

      NAME COCACOLA HOSLICS ICE CREAM BISCUITS
      KADAPA 100
      KADAPA 25
      KADAPA 10
      KADAPA 68
      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        Aug 06, 2021

        Malleshg0072035 

        1) that is separated question, much better to start new thread in such case.

        2) Much better if you provide sample file instead of numbers within post

        3) In general that's job for Power Query - query the table, select name and unpivot other columns

    • winters80's avatar
      winters80
      Copper Contributor
      May 14, 2021

      SergeiBaklan 
      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. 

      • tekhnik's avatar
        tekhnik
        Copper Contributor
        Aug 06, 2021

        winters80I can confirm identical behavior. Same file and same access permissions in SharePoint, but one user can create new rules, and edit existing, while other user can only delete. The first user is a global admin (like your site collection admin). The second user is the file's creator.

        Did you ever figure out the reason? Anything with release schedule preferences?

  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor
    Apr 30, 2021

    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)

Resources