title: Color a few cells according to 1 cell's value
body: <p>I have a hourly plan where time of employees' meetings automatically appears from an other sheet.
  I need it to be marked with specific color according to meeting's lenght.
  Ex.</p>
  <p><code>&quot;</code>A1=0,5 then A1 is blue
  if A1=1 then A1 and A2 is blue
  if A1=1,5 then A1, A2, A3 is blue and etc.<code>&quot;</code></p>
  <p>I only find info how to mark specific cell using conditional formating or VBA, but don't know how to apply formula to the whole table</p>