title: format row(s) based on filter condition in google sheet
body: <p>I have a google sheet that contains rows in sorted order based on a date column. Now I want to highlight the row(make it bold) which is nearest to the current date but not greater than it, i.e., today&gt;=max (dates where date &lt;= current date). Can someone please help me out on how to achieve this?</p>
  <p>--Update--</p>
  <p>I have solved the problem by moving the expression to another cell and then referencing the cell in the conditional formatting from there. Now I have a new problem, I want to generate one cell's value and make that non-editable. In simple words, I want to generate create date of a row and put that date in a column named create date. I think I have to use the google apps script but not sure if the idea of putting a system-generated date in a column is feasible.</p>