SOLVED

Extend conditional formatting range

Copper Contributor

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:

https://1drv.ms/x/s!Ai3wejactZJ_licmHMLM2tBCbH7G?e=H22tsc

 

 

 

1 Reply
best response confirmed by packie (Copper Contributor)
Solution

@packie 

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.

1 best response

Accepted Solutions
best response confirmed by packie (Copper Contributor)
Solution

@packie 

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.

View solution in original post