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...


enter image description here