Re-ordering Conditional Formatting rules on Excel Online

%3CLINGO-SUB%20id%3D%22lingo-sub-3177896%22%20slang%3D%22en-US%22%3ERe-ordering%20Conditional%20Formatting%20rules%20on%20Excel%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3177896%22%20slang%3D%22en-US%22%3E%3CP%3EI%20made%20a%20spreadsheet%20locally%20for%20a%20client%20and%20then%20sent%20it%20over%20for%20them%20to%20upload%20to%20their%20sharepoint%20for%20multiple%20people%20to%20use%20to%20track%20projects.%3C%2FP%3E%3CP%3EIt%20has%20quite%20a%20long%20list%20of%20conditional%20formatting%20rules%2C%20which%20change%20the%20row%20colour%20depending%20on%20the%20status%20and%20then%20it%20has%20a%20final%20one%20that%20searches%20based%20on%20tags%2C%20and%20any%20rows%20that%20contain%20the%20tag%20being%20searched%20for%20are%20highlighted%20differently%20(these%20can%20then%20be%20filtered%20easily%20or%20just%20there%20as%20a%20highlight%20depending%20on%20what%20they're%20doing.)%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20that%20all%20works%20fine%20and%20was%20sent%20and%20uploaded%2C%20and%20I%20was%20given%20back-end%20access%20to%20make%20sure%20it%20all%20works%20fine.%20The%20client%20then%20wanted%20to%20add%20one%20more%20status%20field%2C%20which%20I%20did%2C%20but%20I%20can't%20figure%20out%20how%20you%20change%20the%20order%20of%20the%20conditional%20formatting%20rules%20to%20move%20the%20search%20one%20to%20the%20top%20(if%20it%20isn't%20at%20the%20top%2C%20then%20the%20new%20status%20field%20colour%20overrides%20it%20and%20so%20anything%20that's%20that%20status%20won't%20be%20searchable.)%3C%2FP%3E%3CP%3ESurely%20this%20must%20be%20supported%20in%20Excel%20online%3F%20I%20also%20can't%20just%20delete%20and%20re-add%20the%20search%2C%20as%20there%20also%20doesn't%20seem%20to%20be%20a%20custom%20format%20option%20in%20conditional%20formatting%20in%20online%20and%20the%20default%20formats%20are%20too%20similar%20to%20the%20other%20status%20formats.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20around%20this%2C%20or%20am%20I%20going%20to%20have%20to%20ask%20the%20client%20to%20download%20and%20email%20back%20to%20me%20the%20current%20version%20of%20the%20file%20to%20make%20a%2010%20second%20change%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3177896%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-3177952%22%20slang%3D%22en-US%22%3ERe%3A%20Re-ordering%20Conditional%20Formatting%20rules%20on%20Excel%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3177952%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1310004%22%20target%3D%22_blank%22%3E%40DigimaVP%3C%2FA%3E%26nbsp%3BConditional%20formatting%20was%20introduced%20in%20Excel%20for%20the%20Web%20only%20recently.%20The%20announcement%20mentioned%20this%20for%20future%20developments%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Riny_van_Eekelen_0-1645095443431.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F349028i6932EE37DC3519A3%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Riny_van_Eekelen_0-1645095443431.png%22%20alt%3D%22Riny_van_Eekelen_0-1645095443431.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThus%2C%20reordering%20rules%20isn't%20there%20yet.%20You%20have%20to%20revert%20to%20the%20desktop%20version.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I made a spreadsheet locally for a client and then sent it over for them to upload to their sharepoint for multiple people to use to track projects.

It has quite a long list of conditional formatting rules, which change the row colour depending on the status and then it has a final one that searches based on tags, and any rows that contain the tag being searched for are highlighted differently (these can then be filtered easily or just there as a highlight depending on what they're doing.) 

 

So that all works fine and was sent and uploaded, and I was given back-end access to make sure it all works fine. The client then wanted to add one more status field, which I did, but I can't figure out how you change the order of the conditional formatting rules to move the search one to the top (if it isn't at the top, then the new status field colour overrides it and so anything that's that status won't be searchable.)

Surely this must be supported in Excel online? I also can't just delete and re-add the search, as there also doesn't seem to be a custom format option in conditional formatting in online and the default formats are too similar to the other status formats. 

 

Is there a way around this, or am I going to have to ask the client to download and email back to me the current version of the file to make a 10 second change? 

1 Reply

@DigimaVP Conditional formatting was introduced in Excel for the Web only recently. The announcement mentioned this for future developments:

Riny_van_Eekelen_0-1645095443431.png

Thus, reordering rules isn't there yet. You have to revert to the desktop version.