Conditional Formatting On Multiple Ranges

[martinmc]

Hi, Can you please help me with conditional formatting (highlight both cells) as with the below example to highlight the name "Mary" in the "NAME and "Qty" Columns on ranges A3:B7, C3:D7, E3:F7. I'm new here and its my first ever post,Thank You in advance.

[TABLE="class: outer_border, width: 500, align: left"]
<tbody>[TR]
[TD]SHIFT 1[/TD]
[TD]
[/TD]
[TD]SHIFT 2[/TD]
[TD]
[/TD]
[TD]SHIFT 3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]NAME[/TD]
[TD]QTY[/TD]
[TD]NAME[/TD]
[TD]QTY[/TD]
[TD]NAME[/TD]
[TD]QTY[/TD]
[/TR]
[TR]
[TD]Mary[/TD]
[TD]25[/TD]
[TD]Bob[/TD]
[TD]54[/TD]
[TD]Mary[/TD]
[TD]50[/TD]
[/TR]
[TR]
[TD]Tony[/TD]
[TD]154[/TD]
[TD]Mary[/TD]
[TD]35[/TD]
[TD]Tony[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Denis[/TD]
[TD]200[/TD]
[TD]Bob[/TD]
[TD]321[/TD]
[TD]Mark[/TD]
[TD]147[/TD]
[/TR]
[TR]
[TD]Mary[/TD]
[TD]35[/TD]
[TD]Tony[/TD]
[TD]210[/TD]
[TD]Bob[/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]320[/TD]
[TD]Mary[/TD]
[TD]100[/TD]
[TD]Denis[/TD]
[TD]54[/TD]
[/TR]
</tbody>[/TABLE]



[TABLE="width: 384"]
<colgroup><col width="64" span="6" style="width:48pt"></colgroup><tbody>[TR]
[TD="class: xl68"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"] [/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 0"]
<tbody>[TR]
[TD="colspan: 2"][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 0"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Fluff]

Hi & welcome to MrExcel.
Select A3:E7 & use this formula
=A3="Mary"
Then select B3:F7 & use the same formula

 

[martinmc]

Thank you for you swift response, excellent , works a harm.

 

[Fluff]

You're welcome & thanks for the feedback.