Re: $$Excel-Macros$$ Conditional Formatting using VBA

Derived this from Noorain wondeful Solution. Some changes in the way if have used vba. Sub CF() Dim CelRng As Range LastRow = Range("B3").End(xlDown).Row Set CelRng = Range("B3:B" & LastRow) For i = 3 To LastRow If Cells(i, "B").Value < Application.WorksheetFunction.Aver

Re: $$Excel-Macros$$ Conditional Formatting using VBA

Dear George, Consider this one. On Wed, Dec 7, 2011 at 11:06 AM, George Barrowcliff wrote: > > Excel 2007- > > I have a spreadsheet that is updated frequently with new rows of data. > > I have a conditional format that is set for all rows and each time I add a > new row I have to manually adjust

Re: $$Excel-Macros$$ Conditional Formatting using VBA

Dear George, Please see attached sheet, I hope it will help to u. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Wed, Dec 7, 2011 at 11:06 AM, Georg

$$Excel-Macros$$ Conditional Formatting using VBA

Excel 2007- I have a spreadsheet that is updated frequently with new rows of data. I have a conditional format that is set for all rows and each time I add a new row I have to manually adjust the last row to encompass the newly added one. In the attached spreadsheet, new SKU data is added at the