SOLVED

# Extend conditional formatting range

Copper Contributor

# 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

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

best response confirmed by packie (Copper Contributor)
Solution

# Re: Extend conditional formatting range

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

# Re: Extend conditional formatting range

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.