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 going on with the other cells in the range H5:J8


Please see sample sheet:!Ai3wejactZJ_licmHMLM2tBCbH7G?e=H22tsc




1 Reply
best response confirmed by packie (Contributor)


Change the formula in the conditional formatting rule from




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.