Conditional formatting

[christinekenny]

In conditional formatting I would like to highlight the whole row when yes is entered into cell M2 then each row after that.
Sorry cannot paste table into here

Thank you for any assistance

[TABLE="width: 2316"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col span="2"></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Peter_SSs]

Select From A2 down & right so you have the whole range where this might apply selected then in Conditional Formatting choose
New Rule - Use a formula ... - Format values where this formula is true: =$M2="Yes" - Format... - Choose formatting - OK - OK

 

[christinekenny]

thank you so much

 

[Peter_SSs]

thank you so much

You're very welcome. Thanks for the follow-up.