title: Conditional formatting in Google Sheets: Can I use custom function in the 'custom formula is:' field?
body: <p>While applying conditional formatting in Google spreadsheet, I was wondering if it's possible to use a custom function that I created via script editor in the field 'custom formula is:'. Here is what I did: </p>
  
  <ol>
  <li><p>Went to 'script editor' and typed my fn as follows:</p>
  
  <pre><code>function foo (param1, param2, param3) {
    if (condition to check) {
      ...some action;
      return true;
    } else {
      return false;
    }
  }
  </code></pre>
  
  <p>and saved.</p></li>
  <li><p>In sheet, selected cells and opened 'conditional formatting' dialog</p></li>
  <li><p>Created new rule and in the field 'custom formula is:' typed the following</p>
  
  <pre><code>=foo(param1, param2, param3)
  </code></pre></li>
  </ol>
  
  <p>Unfortunately, this didn't work. </p>
  
  <hr>
  
  <p>Addition</p>
  
  <p>Here is the <a href="https://docs.google.com/spreadsheets/d/17cN-IgZl8qeUYecMl1O4mkvcueCUJIZKksf01kqowws/edit?usp=sharing" rel="nofollow">sample sheet</a>...</p>
  
  <p>See the two tasks in there. My aim is to have the 'task title' automatically written inside of the yellow field (see the task in row 6 where I entered the value manually). </p>
  
  <p>What I already tried was: 
  - Assign to every cell in range <code>H5:BB7</code> following formula: <code>=if(H$4=D5; B5; "")</code><br>
  This checks if the start date equals the cell date and displays the task title.
  That does the trick, however the content of the cell with task title is clipped even if 'overflow' is on because the next cell is not empty.</p>