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.

SHIFT 1		SHIFT 2		SHIFT 3
NAME	QTY	NAME	QTY	NAME	QTY
Mary	25	Bob	54	Mary	50
Tony	154	Mary	35	Tony	2
Denis	200	Bob	321	Mark	147
Mary	35	Tony	210	Bob	200
Mark	320	Mary	100	Denis	54

<tbody>
</tbody>

<colgroup><col width="64" span="6" style="width:48pt"></colgroup><tbody>
</tbody>

<tbody>
</tbody>

<tbody>
</tbody>

 

[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.