I have an excel sheet that for the forseeable future will remain as a Work In Progress regarding a project. To easily be able to keep track of rows that need some work I would like to create a macro that changes the background color depending on certain rules, according to this pseudo-code:
For each row n {
if any cell on row n contains a question mark, background of cell [A,n] should be red
if cell [B,i] is empty, background of cell [A,n] should be red
}
What's the easiest way to implement above pseudo-code to rows 4 to, say... 1000?
Note regarding the question mark:
It may be a standalone question mark, or it will be text followed by a question mark. I want it to match any question mark on that row.
Note regarding rule precedence:
If both rules were to trigger on the same row, I want the cell to end up red.