GASで文字色を判定・取得！getFontColorObjectで条件分岐を自動化する方法

function getSingleCellFontColor() {
  const sheet = SpreadsheetApp.getActiveSheet();
  const targetCell = sheet.getRange("B2");
  
  // Colorオブジェクトを取得
  const colorObject = targetCell.getFontColorObject();
  
  // RgbColorオブジェクトに変換してから16進数文字列を取得
  const hexCode = colorObject.asRgbColor().asHexString();
  console.log("16進数コード:", hexCode);
  
  // RgbColorオブジェクトから各色成分を取得
  const rgbColor = colorObject.asRgbColor();
  console.log(`RGB値: R=${rgbColor.getRed()}, G=${rgbColor.getGreen()}, B=${rgbColor.getBlue()}`);
}

function getMultipleCellFontColors() {
  const sheet = SpreadsheetApp.getActiveSheet();
  const range = sheet.getRange("A1:C5");
  // Colorオブジェクトの二次元配列を取得
  const fontColorObjects = range.getFontColorObjects();
  
  fontColorObjects.forEach((row, rowIndex) => {
    row.forEach((colorObject, colIndex) => {
      const cellAddress = range.getCell(rowIndex + 1, colIndex + 1).getA1Notation();
      const hexCode = colorObject.asRgbColor().asHexString();
      console.log(`セル ${cellAddress} の色: ${hexCode}`);
    });
  });
}

function listUpRedFontCells() {
  const sheet = SpreadsheetApp.getActiveSheet();
  const range = sheet.getDataRange();
  const fontColors = range.getFontColorObjects();
  const values = range.getValues();
  const redFontCells = [];

  fontColors.forEach((row, rowIndex) => {
    row.forEach((color, colIndex) => {
      if (color.asRgbColor().asHexString() === "#ff0000") {
        const cellAddress = range.getCell(rowIndex + 1, colIndex + 1).getA1Notation();
        redFontCells.push({
          address: cellAddress,
          value: values[rowIndex][colIndex]
        });
      }
    });
  });

  console.log("赤文字のセル一覧:", redFontCells);
}

function setStatusByFontColor() {
  const sheet = SpreadsheetApp.getActiveSheet();
  const targetRange = sheet.getRange("A2:A" + sheet.getLastRow());
  const colors = targetRange.getFontColorObjects();

  colors.forEach((row, index) => {
    const colorHex = row[0].asRgbColor().asHexString();
    const statusCell = targetRange.offset(index, 1); // 隣のセル(B列)

    switch (colorHex) {
      case "#ff0000": // 赤色
        statusCell.setValue("要対応");
        break;
      case "#0000ff": // 青色
        statusCell.setValue("完了");
        break;
      default:
        statusCell.clearContent();
        break;
    }
  });
}