在电子表格中添加批注并更改单元格颜色

为所选单元格添加批注，也可以更改单元格的背景颜色。

(function () {
  let worksheet = Api.GetActiveSheet();
  let range = Api.GetSelection();
  range.ForEach(function (range) {
    let sValue = range.GetValue();
    if (sValue > 100) {
      range.AddComment("The value is bigger than 100.");
      range.SetFillColor(Api.CreateColorFromRGB(255, 213, 191));
    } else {
      range.AddComment("The value is less than 100.");
      range.SetFillColor(Api.CreateColorFromRGB(204, 255, 255));
    }
  });
})();

使用方法: GetActiveSheet, GetSelection, ForEach, GetValue, AddComment, SetFillColor, CreateColorFromRGB

参考 Microsoft VBA 宏代码

Sub SimpleAddCommentsAndChangeColor()
    Range("A1").ClearComments
    Range("A1").AddComment "This is a comment for A1"
    Range("A1").Interior.Color = RGB(255, 255, 0)
End Sub

结果