Forum Discussion
Solved
Extend conditional formatting range
I need to create a range so that the result for H5 can be extended to H5:J8 If you can treat H5 as being the correct outcome of the formatting then it may be easier to understand what might be go...
Change the formula in the conditional formatting rule from
=$D$5
to
=$D5
Removing the $ from before the row number 5 makes that row number relative (dynamic): Excel will compare cells in H5:J5 to D5, but cells in H6:J6 to D6, etc.
Change the formula in the conditional formatting rule from
=$D$5
to
=$D5
Removing the $ from before the row number 5 makes that row number relative (dynamic): Excel will compare cells in H5:J5 to D5, but cells in H6:J6 to D6, etc.