Take the formatting of another cell : I have following table in Google Sheets with conditional formatting in the 2nd row - Color scale. I would like to make the first row colored the same way as the second one.

[![enter image description here][1]][1]

Is there any option how to dynamically "copy" format of another cell?

I just do not want to do it manually all the time - like 5 conditional formatting for cells A1:L1 where will be =IF(A2<350) then use color1. If A2<300 use the color2. And so on...


  [1]: https://i.stack.imgur.com/jE8il.png