Copying conditional formating parameters with changing cell values

[dmxcasper2]

Problem:
1. I am trying to create conditional formatting with a dynamic Cell Value.
2. When I drag copy the format in Column H, the cell value circiled below stays static as opposed to changing to D3.

Any help is appreciated.

 

[Joe4]

When you look at the formula in Conditional Formatting, it will also show the formula as it appears to the very first cell in the range it is applied to.
So, if it is applied to range H2:H6, the formula displayed will always be in relation to cell H2.
But as long as you have applied absolute/relative range referencing in your formula correctly, it will automatically adjust that formula for the other cells.

 

[dmxcasper2]

When you look at the formula in Conditional Formatting, it will also show the formula as it appears to the very first cell in the range it is applied to.
So, if it is applied to range H2:H6, the formula displayed will always be in relation to cell H2.
But as long as you have applied absolute/relative range referencing in your formula correctly, it will automatically adjust that formula for the other cells.

Thank you for the response.

How can copy this formatting across 100 cells that mimic this?

Cell Value = D2, Applies to H2
Cell Value = D3, Applies to H3
Cell Value = D4, Applies to H4

 

[Joe4]

Thank you for the response.

How can copy this formatting across 100 cells that mimic this?

Cell Value = D2, Applies to H2
Cell Value = D3, Applies to H3
Cell Value = D4, Applies to H4

I have the Format Copier to be a bit fickle.
I have much better luck selecting the whole range that you want to apply the Conditional Formatting to (i.e. H2:H100).
I also like to use the "Use a formula to determine which cells to format" option.
Then just write the formula you want to use as it applies to the first cell in that range (H2), and the formula will automatically adjust for the rest of the cells in your selection.

Doing this, you can actually combine your two green rules into one rule, like this:

=H2<=D2

and then your red formatting rule would just be:

=H2>D2