Fill down option not to interrupt conditonal formatting

[kosherboy]

Hello.
Below is a code that works for this attachment Invoice.xlsm
When you hit the code you will see how the 2 left most columns disrupt the conditional formatting resulting in one color for those columns as opposed to every second row with one color and the rows between them another color.
Can anyone modify this code so that the conditional formatting remains the same? (I highlighted the part in the code that needs attention)
Many thanks

Please Login or Register  to view this content.

[ianxwood]

The code works fine you just have to change the way you`re doing the conditional formatting as follows

Please Login or Register  to view this content.

and apply to the entire range, see attached.

Regards
Ian

[ianxwood]

Slight correction the condition formula should be

Please Login or Register  to view this content.

Regards
Ian

[kosherboy]

Wow, cool! Thanks. Can you just show me how to put a border around all the data in the Conditional? My original attachment has borders.

[kosherboy]

This thread is solved.
Thanks