Conditional formatting based on two criteria

Hi all,

I have a macro that runs on another workbook to format it for the user. I would like ONLY the cells in the E column where the cell above in the A column is equal to the current cell in the A column and the DAY value for days wait (E column) is greater than 7 to be highlighted. I basically want it highlight the cells where the days wait is greater than 7.

Here's what I have so far:

Please Login or Register  to view this content.

But it still doesn't seem to get them to be highlighted.

Please see the attached file to see example of the unhighlighted version and the what the finished version should look like.

Example.xlsx

Thanks for you anticipated help.

Originally Posted by sky1in5

when i run your code

it show error at this line

Please Login or Register  to view this content.

Sorry that should be:

Please Login or Register  to view this content.

Originally Posted by sky1in5

same, error.

Here's my current code:

Please Login or Register  to view this content.

I'm hoping you can tell me where I'm going wrong...

EDIT: Solved by recording my actions.