EPPlus双色条件日期格式

using OfficeOpenXml;
using OfficeOpenXml.ConditionalFormatting;

// 创建Excel文件
var fileInfo = new FileInfo("example.xlsx");
using (var package = new ExcelPackage(fileInfo))
{
    var worksheet = package.Workbook.Worksheets.Add("Sheet1");

    // 添加日期数据
    worksheet.Cells["A1"].Value = "Date";
    worksheet.Cells["A2"].Value = new DateTime(2022, 1, 1);
    worksheet.Cells["A3"].Value = new DateTime(2022, 1, 15);
    worksheet.Cells["A4"].Value = new DateTime(2022, 2, 1);
    worksheet.Cells["A5"].Value = new DateTime(2022, 2, 15);

    // 创建条件格式对象
    var conditionalFormatting = worksheet.ConditionalFormatting.AddConditionalFormatting(worksheet.Cells["A2:A5"]);

    // 添加日期条件
    var dateCondition = conditionalFormatting.AddDateOccurring();
    dateCondition.Style.Fill.BackgroundColor.Color = Color.Red; // 设置条件格式的背景色
    dateCondition.Style.Font.Color.Color = Color.White; // 设置条件格式的字体颜色
    dateCondition.Formula = "=$A$2"; // 设置日期条件为与A2单元格相同的日期

    // 保存Excel文件
    package.Save();
}