Color if date in column n and stop color at column n

I'm trying to change the color of a row if there is a date in column "N". I want it to only color from column "A" to "N" of that row. I have a code but it colors the entire row instead of stopping at "N".

Please Login or Register  to view this content.

Hi Dalet,

Try changing

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Where 1 = column A and 14 = column N (14th letter of the alphabet).

Wow, I must have had an off-moment.. mixed up the row/column refs.. use:

Please Login or Register  to view this content.

Yes, just loop through the sheets and put your code inside the loop, e.g.

Please Login or Register  to view this content.

Obviously you can put more code inside the For/Next loop to suit your needs.