I wrote a conditional formating formula =$M11:$M432 that formats in yellow, and applies to =$A$11:$L$11, which works successfully. The issue is I need to highlight the rows yellow down to Row 432 when Column M is not blank. How should I edit the rule to make each row auto highlight when M has an entry per individual row - Conditional Formatting Rules Manager Excel 2016?
Solved by E. H. in 30 mins