parttime_guy
08-27-2018, 08:52 PM
Hi
Have a code for conditional formatting
Sub FormatTotalRow()
Worksheets(1).Range("K1:K500").Select
For Each c In Selection.Cells
If c.Value >= 350 Then c.Resize(1, 4).Interior.ColorIndex = 50
Next c
End Sub
The above code highlights results in the selected column as well as the following 4 columns 'Resize(1, 4)'
How do you get the code to highlight 4 preceding columns :banghead:
Kindly help
Best Regards
Have a code for conditional formatting
Sub FormatTotalRow()
Worksheets(1).Range("K1:K500").Select
For Each c In Selection.Cells
If c.Value >= 350 Then c.Resize(1, 4).Interior.ColorIndex = 50
Next c
End Sub
The above code highlights results in the selected column as well as the following 4 columns 'Resize(1, 4)'
How do you get the code to highlight 4 preceding columns :banghead:
Kindly help
Best Regards