Google-sheets – Conditional formatting of Google SpreadSheet’s cell based on proximity to upcoming date not working as expected

conditional formattinggoogle sheets

A picture is worth thousand words

enter image description here

So, why isn't the first date cell yellow? It's in the selected range

Best Answer

you did not use valid formula...

=TODAY()
=TODAY()+30

enter image description here