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
May 13, 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 05, 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?

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Aug 06, 2021

    tekhnik 

    Does the person who can edit is in the list of targeted users?

    • tekhnik's avatar
      tekhnik
      Copper Contributor
      Aug 06, 2021
      Our entire tenancy is on standard release, but I am enabling targeted to the non-edit user to see if they get the capability, in which case i will assume the edit-allowed user may have had targeted enabled in the past.