Filter Number ("between") then return with some tagging

[Megat91]

How to do VBA on filter the "Cost" collumn with some range
Example like "is greater than or equal to" = 2000 or "is less than or equal to" = -2000, return tag collum "Cost Group" with "< 2k" group
then so on like the picture outcome from yellow to green
btw, i will have different set of data with different number of rows each time doing

Thanks for the help

 

[kvsrinivasamurthy]

Formula will do. Is it Ok.
In D3

=IF(C3=0,"",IF(ABS(C3)<1000,"<1k",IF(ABS(C3)<2000,">1K", ">2K")))

 

[Megat91]

But i need some VBA code, as i come from a very raw downloaded data to this kind of format arrangement, so thinking of inserting the VBA together with my previous step

 

[kvsrinivasamurthy]

VBA code.
Assumed green column starts with D3

Sub Macro2()
Dim LR As Long
'Assumed green column starts with D3
LR = Range("d" & Rows.Count).End(xlUp).Row
With Range("d3:d" & LR)
.Formula = "=IF(C3=0,"""",IF(ABS(C3)<1000,""<1k"",IF(ABS(C3)<2000,"">1K"", "">2K"")))"
.Value = .Value
End With
End Sub