Excel VBA: Check each row for conditions. Help!
 

Hi

If the following conditions are met:

For any given row between row 10 and row 100 inclusively:

-The cell in column A is not empty; -The cell in column B is not empty; -The cell in column O is empty.

I would like to highlight a specific cell (let's say A1).

Example:

I populate A10 and E10 while leaving O10 empty, then cell A1 gets highlighted. If I then populate cell O10, the highlight in cell A1 disappears.

I can proceed to the next row. Any row at any time should generate these actions.

Thanks!