I have a cell (A7), that is conditionally formatted (color changes depending on the ascending value of the percentage). I want to apply this same color change to cells A1:A6. Is there any way to do this that does not require code work?

As an FYI, A7 value is based on another cell where the calculation takes places.

Thanks for any help provided!