function onOpen(){
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getActiveSheet();
var menu = []
menu.push({name: "Code couleur Texte", functionName: "ColorFont"});
menu.push(null);
menu.push({name: "Code couleur Fond", functionName: "ColorCellule"});
ss.addMenu("Couleurs", menu);
}


function ColorFont() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getActiveSheet();
var mesLignes = sheet.getLastRow()
sheet.getRange("D2:D").clearContent()
for (var i = 2; i < mesLignes; i++){
var rien = sheet.getRange("B"+i).getValue()
var newcolor = sheet.getRange("B"+i).getFontColor();
if (rien == ""){
}else{
sheet.getRange("D"+i).setValue(newcolor);
}
}
}
function ColorCellule() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getActiveSheet();
var mesLignes = sheet.getLastRow()
sheet.getRange("C2:C").clearContent()
for (var i = 2; i < mesLignes; i++){
var newcolor = sheet.getRange("B"+i).getBackground();
if (newcolor == "#ffffff"){
}else{
sheet.getRange("C"+i).setValue(newcolor);
}
}
}

formule en E2
=ArrayFormula(IF($C$2:$C="";"";hex2dec(mid($C2:C;2;2)) & ","&hex2dec(mid($C2:C;4;2)) &"," &hex2dec(mid($C2:C;6;2))))
formule en F2
=ArrayFormula(IF($D$2:$D="";"";hex2dec(mid($D2:D;2;2)) & ","&hex2dec(mid($D2:D;4;2)) &"," &hex2dec(mid($D2:D;6;2))))