Conditional Formatting for Multiple Rows

Hi Dan,

Thank you for the forum question.

I am not sure why you cannot get it to work because I have just tested it in my sheet.

If you want the condition to work in a whole table select all data (not the headings only the records) and type the formula =$M2="Yes" (where M2 is the first cell in the selection where you can have Yes). It is important that you only have a $ in front of the column.

I also selected only one record (The first record) and did the same as above and then copied the whole record and pasted the formatting only to another record and it worked fine.

There is more methods to highlight a whole row but this method should do what you need.



Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector