Forum Discussion

DEllis1440's avatar
DEllis1440
Copper Contributor
Feb 03, 2022
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...
Excel on Mac
office 365
  • HansVogelaar's avatar
    HansVogelaar
    Feb 03, 2022

    DEllis1440 

    Try Excel menu > Preferences > Color > Copy Colors From

DEllis1440's avatar
DEllis1440
Copper Contributor
Feb 03, 2022

HansVogelaar 

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)

HansVogelaar's avatar
HansVogelaar
MVP
Feb 03, 2022

DEllis1440 

Try Excel menu > Preferences > Color > Copy Colors From

  • DEllis1440's avatar
    DEllis1440
    Copper Contributor
    Feb 03, 2022
    Great! Thank you so much. It's restored the original colour palette.

    Note for anyone else needing to do this, it's actually under
    Excel menu > Preferences > Compatibility > Copy colours from

Resources