Apply the same conditional formatting to another cell when it's applied to others

[Glasgowsmile]

I have this formula for Conditional formatting

=ROUND($D$3*$C7,)>D7

and what I want to do... If the formatting is applied to any cell in range D7:NE41, then I want to apply that same formatting to D45:NE79 - the issue is that if I add that second range to the "Applies to" section of the conditional formatting, it doesn't work likely due to the range in the rule but data only exists up to row 41, so I assume that's why the rule doesn't work. I could create a helper column with the same data but I'm trying to avoid that.

So, I'm looking for a workaround.

My thought right now is below but it's not working, says Object required and I'm not sure what the issue is.

Sub Colors()
If ThisWorksheet.Range("D7:NE41").Interior.Color = &HDA9694 Then
    ThisWorksheet.Range("D45:NE79").Interior.Color = &HDA9694
End If
End Sub

 

[Glasgowsmile]

OK, I see what you mean now (pictures really do "say 1000 words!").

This is actually a lot simpler than you think.
Simply highlight your lower section, and use the EXACT same Conditional Formatting color.

So, for the example above, you would simply select range C9:D12, and enter the Conditional Formatting formula:

=ROUND($C$1*$B3,)>C3

Make sense?

Agreed, my apologies. I should have done that the first time :D

I'm stunned at the solution though. I clearly made this more difficult - thanks!

 

[Joe4]

No worries!

It happens to all of us some time. Sometimes we cannot see the forest for the trees and overlook the obvious.
Sometimes, you just need a fresh set of eyes to see it.