Conditional formatting

christinekenny

New Member
Joined
Oct 14, 2019
Messages
8
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


<colgroup><col><col><col><col><col><col><col><col><col><col><col><col span="2"></colgroup><tbody>
</tbody>
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
41,783
Office Version
365
Platform
Windows
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
 
Last edited:

Forum statistics

Threads
1,078,151
Messages
5,338,531
Members
399,240
Latest member
Anell JvR

Some videos you may like

This Week's Hot Topics

Top