Applying 1 cells conditional formatting to several adjacent cells

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!

Can you not just extend the range in the conditional formatting rules?

hmmm, tried that, but it did not work. In order for that to work, the range would be from cell A1 to A7, where A7 is the cell with the percentage that would drive the format......Not sure how to do that.

K, here it the gist: In this case, it is a little different (my bad).
It is a row of information, with one true data point on the end. So, columns A to G are all informational cells about an activity, with H being the percentage complete. Currently, I have it set that H is a value based on other cells performing a calculation. H is then conditionally formatted such that it is a graded color scale based on the ascending value of the percentage (lower is brighter).

book test description status percentage
1 5 blah blah open 80%

I have it set so that the percentage cell changes color as it nears 100%. I would like it if the entire row changes that same color.

Here is the attached example. Note that for some reason, I could not get it to look exactly like I want. I have a table of information (A3:E6). Column E is the percentage complete. I set up a simple graded color scheme from lowest to highest percentage, to go from Red to Yellow. Sadly, E3 is at 50% and is at yellow. This should not be the case. Not sure what what went wrong there.

The goal is to have all rows have a color based on their E cell color, based on the percentage complete for that row. Hope that helps. I have a feeling that this is super easy.

Couple of things here.

First, the reason that your 50% is yellow is that you have selected Percent. This does not give you a range of colors based on the absolute percent number in the cell. It bases the color on where the value in that cell falls in the range of all cells with that formatting. That is, if you have the numbers

50
70
60
75

It will treat 50 (lowest number) as the 0% point and 75 (highest number) as the 100% point for purposes of formatting. 60 will be treated as 40%, and 70 will be treated as 80%.

In your case, you want to use Number, and use the range 0 and 1. That will give you the colors you are expecting.

Now, the bad news. This formatting rule works only to format the cell containing the value that determines the color. You cannot use the graded color scale to format other cells. So the only way to do what you want to do is define a separate rule for each color you want to use, instead of letting Excel select the color from a gradient. Then you would use the technique I described above.

Alright! I understand. Thanks for the help!

Here is an example using four colors for 0-25%, 25-50%, 50-75%, 75-100%