使用condformat包格式化DataFrame时列条件着色问题求助

• 核心原因：rule_fill_discrete的设计初衷是基于单列自身的离散取值实现着色，而你需要的是跨列比较的二元判断（匹配/不匹配），改用rule_fill函数更适配这种场景。
• 修改后的可运行代码：

library(condformat)

my_df <- data.frame(
  Percentage = runif(10),
  AnswerA = c("A", "A", "B", "B", "C", "C", "D", "D", "E", "E"),
  AnswerB = c("A", "A", "A", "B", "C", "C", "D", "D", "D", "E")
)

my.df.cf <- condformat(my_df) %>%
  # 高亮Percentage列：低于20%或高于80%
  rule_fill_discrete('Percentage',
                     expression = cut(Percentage, breaks = c(0, 0.2, 0.8, 1), include.lowest = TRUE, labels = FALSE),
                     colours = c('1' = 'firebrick1', '2' = 'white', '3' = 'lightgreen')) %>%
  # 高亮AnswerA和AnswerB不匹配的单元格
  rule_fill(c('AnswerA','AnswerB'),
            expression = AnswerA != AnswerB,
            fill = "firebrick1")

# 查看着色结果
my.df.cf

• 关键修改说明：
  1. 保留rule_fill_discrete处理Percentage列的逻辑，这部分实现是正确的。
  2. 替换rule_fill_discrete为rule_fill处理AnswerA/AnswerB列：
     • 直接传入跨列比较逻辑AnswerA != AnswerB，布尔向量会精准对应每个单元格的判断结果。
     • fill参数仅需指定满足条件（不匹配）时的填充色，未满足条件的单元格默认保持白色，无需额外配置。

内容的提问来源于stack exchange，提问作者VikkiO