抽出するquery関数(A1にtoday)
GAS
=QUERY('フォームの回答 1'!A:B, "SELECT * WHERE dateDiff(A, date '" & TEXT(A1, "yyyy-mm-dd") & "') = 0")
期限を過ぎていた場合の条件付き書式
条件付き書式
=HOUR(A1) >= 8
追記:todayの部分はカレンダーでもいいかもしれない。
More than 1 year has passed since last update.
Register as a new user and use Qiita more conveniently
- You get articles that match your needs
- You can efficiently read back useful information
- You can use dark theme