Dan has attended:
Excel Intermediate course
Excel Advanced course
Conditional Formatting for Multiple Rows
Hi,
I need to format a workbook in the following way:
Once the word "Yes" is entered into a cell, the whole row will be formatted in grey. I've managed to format one row with the correct formula and format. However, can you help me with how I apply this to each row individually? It seems pretty much impossible!
I've tried to paste special and tried to use the format painter etc. but I just can't seem to work this one out.
Do I need a macro?!
Any help is much appreciated, I'm sure there's a better way.
Many thanks,
Dan
RE: 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
