Conditional formatting - cell equals another cell, formats range of cells - quick apply to multiple ranges needed

[Robisbald]

Okay, so whether this is done by VBA or the conditional formatting tool isn't important to me, either would be fine. But at the moment I'm adding each rule manually in the conditional formatting tool and I've got about 200 of these to do and I know an expert out there has an easy solution for this

So as an example (and seen on the image attached), I want cells B11:G11 to have the interior colour changed to green when cells D11 & F11 equal each other. But I want this to continue for a specific range of rows below:
when D11=F11 affects B11:G11
when D12=F12 affects B12:G12
when D13=F13 affects B13:G13
when D14=F14 affects B14:G14
when D15=F15 affects B15:G15
note they will be row where I don't want this applying to, so the rows will skip a few before I want the conditional formatting to apply again:
when D20=F20 affects B20:G20
when D21=F21 affects B21:G21
when D22=F22 affects B22:G22

I've tried copy and paste special formatting but this doesn't work, might be doing something wrong, but read that its not great when using a formula based rule?

Thanks

 

[etaf]

ok
so i have select contiguous ranges $D$11:$G$15,$D$20:$G$22
for conditional formatting


and also added part of the rule IF D11<>"" then do not apply the colour so info needs to be entered into the cell to work
otherwise a blank = blank and it will colour all empty cells
many different ways to do that

Rule - =AND($D11<>"",$D11=$F11)

Book1
	A	B	C	D	E	F	G	H
1
2
3
4
5
6
7
8
9
10
11				1	1	1
12				2
13
14
15				4		4
16
17				12		12
18
19
20				2		2
21
22
23
24
Sheet3

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D11:G15,D20:G22	Expression	=AND($D11<>"",$D11=$F11)	text	NO

Note i used command key to select non-contigous on a Mac
Control key on windows

for 2007, 2010 , 2013 , 2016 , 2019 or 365 Subscription excel version
Conditional Formatting

Highlight applicable range >>
$D$11:$G$15,$D$20:$G$22 - Change, reduce or extend the rows to meet your data range of rows

Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=AND($D11<>"",$D11=$F11)

Format [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK

 

[Robisbald]

Works a treat, thanks

 

[etaf]

you are welcome