1
In the end =COUNTIF($B1:$B100,"month")>1 worked, no quotation marks. I thougth I tried it before
1
I think the relative and absolute reference would help you with this.
There are 3 types of them:
$A1 Allows the row reference to change, but not the column reference.
A$1 Allows the column reference to change, but not the row reference.
$A$1 Allows neither the column nor the row reference to change.
In your case, I think you only want the column ...
1
This should do the trick:
and(today()>start_date,today()<end_date)
1
Use the conditional formula =$B2>$D$5.
Only top voted, non community-wiki answers of a minimum length are eligible
