这是指向我的Google表的链接：
我正在尝试根据似乎无法正常工作的日期来创建条件格式。
这是我的公式：
=isnumber(vlookup(C12,$K$60:$K$71,1,0))
由于日期问题，我使用 = isnumber 。问题在于，只有选择有条件格式化的单元格的第一个单元格是在改变颜色，我知道这是不正确的，因为第一个单元格甚至没有日期编号。
我在做什么错？
Here is the link to my google sheet:
https://docs.google.com/spreadsheets/d/1toBfSTFwIzlUOVZrWWjmhIOZizXuiJ091dYN70kZHcA/edit?usp=sharing
I am trying to create conditional formatting based on a range of dates which does not seem to be working.
This is my formula:
=isnumber(vlookup(C12,$K$60:$K$71,1,0))
I used =isnumber because of the date issue. The problem is that only the first cell of the cells selected to be conditionally formatted is changing color which I know is incorrect because the first cell does not even have a date number.
What am I doing wrong?
发布评论
评论（1）
像这样尝试：
什至：
try like this:
or even: