M mdavid Member Nov 15, 2018 #1 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: Code: lRow = Cells(Rows.Count, 2).End(xlUp).Row Thanks David
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: Code: lRow = Cells(Rows.Count, 2).End(xlUp).Row Thanks David
A Ajesh Active Member Nov 16, 2018 #2 This should give you a start: https://bettersolutions.com/excel/conditional-formatting/vba-code.htm For E.g. Range("B1:B"& lRow).FormatConditions Thanks/Ajesh
This should give you a start: https://bettersolutions.com/excel/conditional-formatting/vba-code.htm For E.g. Range("B1:B"& lRow).FormatConditions Thanks/Ajesh
