My code is not working
Error: Invalid procedure call and argument
Dim lr_cmp_frml As Long
Dim rng_cmp_frml As Range
'Find lr row in col G
lr_cmp = Cells(Rows.Count, "G").End(xlUp).Row
'Setup range
Set rng_cmp_frml = pws.Range("G5:G" & lr_cmp)
rng_cmp_frml.FormatConditions.Add xlCellValue, xless, "=0.59"
rng_cmp_frml.FormatConditions(1).Interior.Color = RGB(255, 127, 127)
Error: Invalid procedure call and argument
Dim lr_cmp_frml As Long
Dim rng_cmp_frml As Range
'Find lr row in col G
lr_cmp = Cells(Rows.Count, "G").End(xlUp).Row
'Setup range
Set rng_cmp_frml = pws.Range("G5:G" & lr_cmp)
VBA Code:
'Format each cells
rng_cmp_frml.FormatConditions(1).Interior.Color = RGB(255, 127, 127)