View Single Post
  #1   Report Post  
pat767 pat767 is offline
Junior Member
 
Posts: 1
Default 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!