Select Row2 to bottom row
Go to Home menu: Conditional Formatting: Manage Rules
Click New Rule.. and select use formula to determine which cells to format
Enter Formula: =AND($A2<>"",$F2=$F3,$G2:$G3,$H2=$H3,$L2=$K3)
Click Format and choose from the Pattern Tab
Click Ok
Click New Rule.. and select use formula to determine which cells to format
Enter Formula: =AND($A2<>"",$F4=$F3,$G3:$G4,$H4=$H3,$K4=$L3)
Click Format and repeat as above..
Bookmarks