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!
|