How To Apply Shading To Odd Or Even (Alternative) Rows (1 Viewer)

[zezo2021]

Hello friends
Solved thanks
I want when adding a row in the sheet (Worksheet_Change(ByVal Target As Range))
the row change odd row change to gray
Even row change to blue
when the row has a value in column (B)

 

[Uncle Gizmo]

Solved thanks

I note that you have solved your problem yourself. The only reason I am posting this message is so that you are aware that unanswered posts are regularly checked./..