How to use conditional formatting in specific column each cells

[seancoo]

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)

'Format each cells

rng_cmp_frml.FormatConditions.Add xlCellValue, xless, "=0.59"
rng_cmp_frml.FormatConditions(1).Interior.Color = RGB(255, 127, 127)

 

[kevin9999]

It would help if you could provide your entire code, and also if you could post a small sample of your sheet using the XL2BB add in, or alternatively share your file via Google Drive, Dropbox or similar file sharing platform?

 

[Peter_SSs]

Welcome to the MrExcel board!

It would help if you could provide your entire code

I agree with @kevin9999 on this. Also, please review my signature block below & its links about how to post vba code in the forum.

However, in relation to your problem, my best guess is that you change xless to xlLess

It also looks to me like lr_cmp in your code possibly should be lr_cmp_frml since that is what is in your variable declaration at the top.

 

[seancoo]

Hi I already resolved the issue thank you guys

 

[Peter_SSs]

Cheers, thanks for letting us know.