#### Abhishekghorpade

##### Board Regular

- Joined
- Oct 3, 2018

- Messages
- 71

I am looking for VBA to highlight the entire rows which satisfy any one of the following conditions for active sheet.

1. IF Column J blank and Column R has some data then Highlight(vbyellow)

2. If Column P and Column R both are ‘0’ and column J is ‘A’ then highlight (vbyellow)

3. Either Column S or T has ‘0’ (Both has value ignore and both has 0 ignore) highlight (vbyellow)

4. If column H is less than 2018 and has value in Column R & P then highlight (vbyellow)

5. If column B has duplicate that is same Name and Column E and F also matches then Highlight