I have a fixed cell $I$1 containing the current date. I have col D whose cells each contain a date. I also have col F which contains a percentage (there is one of these wherever corresponding col D cell has a date).
我有一个包含当前日期的固定单元格$ I $ 1。我有col D,其中每个单元格都包含一个日期。我也有col F,它包含一个百分比(在相应的col D单元格有日期的地方有其中一个)。
The conditional formatting I want is: If date in col D is before date in $I$1 AND percentage in corresponding cell of col F is greater than 0, then set format.
我想要的条件格式是:如果col D中的日期在$ I $ 1的日期之前,并且col F的相应单元格中的百分比大于0,则设置格式。
Based on previous answers on this site, I've tried the "=AND(AND(...;...);...)" method as well as the "multiplication method". Any hints from an expert (since I'm, obviously, not one!)?
基于此网站上的先前答案,我尝试了“= AND(AND(...; ...); ...)”方法以及“乘法方法”。来自专家的任何提示(因为我显然不是一个!)?
2 个解决方案
#1
3
This should do it - For example, supposing you wanted to do this formatting for a cell in row 1:
这应该这样做 - 例如,假设您想要为第1行中的单元格执行此格式化:
=And($D1 < $I$1, $F1 > 0)
#2
2
I have tried it along the lines you suggest and it seems to work OK:
我按照你建议的方式尝试了它,似乎工作正常:
=AND(D1<$I$1;E1>0)
Is this what you want?
这是你想要的吗?
#1
3
This should do it - For example, supposing you wanted to do this formatting for a cell in row 1:
这应该这样做 - 例如,假设您想要为第1行中的单元格执行此格式化:
=And($D1 < $I$1, $F1 > 0)
#2
2
I have tried it along the lines you suggest and it seems to work OK:
我按照你建议的方式尝试了它,似乎工作正常:
=AND(D1<$I$1;E1>0)
Is this what you want?
这是你想要的吗?