I am currently building a spreadsheet using Excel Online in One Drive. The source spreadsheet has highlighted cells using colours which are user defined not conditional formatting. When I try to copy source to online version it won’t bring across cell colours.
I know it’s possible using VBA code, my issue is Excel Online does not support VBA. Very frustrated Excel user