An error occurred while saving the commentRodB commented
Interesting that if you have rules in desktop Excel and upload to OneDrive, they DO get applied when viewing the spreadsheet Online. I'm using fill colours to highlight certain text values. BUT patterns (e.g. cross-hatch) DON'T appear online. Also, if you apply a rule *online*, with the limited colours available there, then edit the spreadsheet in desktop you can "manage rules" and change the colour for that rule to ANY custom colour and when you view the sheet online you'll see the custom colour you picked in desktop. But in the online view you can't even edit the colour you choose for the rule, even to change it to one of the other limited colour sets.
I guess the "rule" is use desktop view to edit your rules?? And don't expect patterns to show in the online view.
Bewildering!RodB supported this idea ·