Forum Discussion
Solved
Global conversion of 'fill colour' needed, e.g. find 'fill colourA' ' replace with 'fill colour B'
I had an Excel spreadsheet created in October 2015 which contained a lot of conditional formatting, specifically assigning colours to cells depending on their numerical values. It consisted of nearly...
Try Excel menu > Preferences > Color > Copy Colors From
Thanks but I can't find any mention of colour palette, nor do I have File > Options.
This is all I have under File
I tried the Save option but there were no options like the ones you showed.
I'm using Excel for Mac version 16.54 (Microsoft 365 subscription)
Try Excel menu > Preferences > Color > Copy Colors From