Conditional formatting does not work, please help

[daydream1989]

Hi, i want to set to format the whole row to red colour if the status is showing 'open', and i have a list in datavalidation. I put the formula like this but the row colour does not change at all. please help

[#2]

What is your apply range. Apply range must be start from $J2.

[#3]

@Harun24HR 

This is my formula and apply range

[#4 · Accepted solution]

@daydream1989 

It shall work

[#5]

it works now after i use a new excel file. thanks.

[#6]

@daydream1989 , you are welcome