答案1
- 选择您的表格/列表,转到条件格式并创建新规则。
- 选择
Use a formula to determine which cells to format
。 - 类型
Format values where this formula is true
=COUNTIF($I2,"")>0
- 选择要突出显示的颜色并完成。
Use a formula to determine which cells to format
。Format values where this formula is true
=COUNTIF($I2,"")>0