Hi, Like to know what to write for conditional formatting - Applies to - from row 2 to end like in vba for end of sheet I can write: lRow = Cells(Rows.Count, 2).End(xlUp).Row Thanks David