条件格式：合并多个检查 [英] Conditional formatting: combining multiple checks

问题描述

现在我检查单元格是否为空白，如果为空，则变为红色。

  = ISBLANK（$ B $ 12）
  

但是，此单元格仅在为空且满足其他条件时才需要为红色

我尝试执行以下操作：

  = ISBLANK（$ B $ 12），（$ B $ 11）=！ NO 
  

但这实际上并没有用。

解决方案

Right now I check if a cell is blank, if it is, it becomes red.

=ISBLANK($B$12)

However this cell only needs to be red when it's empty AND another condition is met: the cell above needs to be set to "YES" or blank.

I tried doing something like:

=ISBLANK($B$12),($B$11)=!"NO"

But that doesn't really work.

解决方案

The AND function can combine the logic in the manner you are looking for. Try the following,

=AND(ISBLANK($B$12), NOT($B$11="NO"))
'or,
=AND($B$12="", $B$11<>"NO")

You will likely want to remove the $ absolute anchor from either the row or column if you want to apply that condition to more than a single cell.

These formulas are applied with the 'Use a formula to determine which cells to format' option. They are put into the 'Format values where this formula is true:' text box.

 

这篇关于条件格式：合并多个检查的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！