see attached workbook
Hi
Need a macro that will edit the backgorund colour in row 21:26 column b irrespective where the data lies in column B if records increase or decrease over time.
So backgound colour transparnet NO FILL.
see attached workbook
Hi
Need a macro that will edit the backgorund colour in row 21:26 column b irrespective where the data lies in column B if records increase or decrease over time.
So backgound colour transparnet NO FILL.
Are you saying that as you add a new row, it gets coloured and you don't want it to?
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Are you saying that as you add a new row, it gets coloured and you don't want it to? - yes....
100%
ok, i have managed to work out the answer i think here is me vba code
Sub No_Fill_backgroundColour()
With Application
.ScreenUpdating = False
End With
Dim rng As Range, cell As Range
Set rng = Range("B4:B" & Cells(65536, "B").End(xlUp).Row)
For Each cell In rng
If (cell.Offset(0, -1).Value <> "") Then
cell.Interior.ColorIndex = xlNone
End If
Next cell
With Application
.ScreenUpdating = True
End With
End Sub