I'm looking for how to apply conditional formatting to blank cells - but ONLY if the row they are in is not completely blank.
For example, I'm making a project tracking sheet, and I want incomplete stages in projects to stand out. So here is how it looks with a simple "format blank cells" rule applied to the first four rows:
What I want is, as soon as I enter content into the new row, the conditional formatting to apply, like this:
...but I don't want the conditional formatting to apply to every blank row like this, I only want it to apply to rows that have some content. I don't want a big sea of red, I want red only where there is a task that needs doing:
If it's relevant, I'm using the Excel 2016 trial.