Conditional Formatting of complete row based on cell value

[pateltarunt]

I have create my Product Item Data table where I will enter Product name - Item Number - Purchase date - Sales date - Order Number - Status (complete-active-cancelled-hold) etc. required detail in same item number row in different column.

I want to set color change of Product Item Row when I enter Complete-Active-Cancelled-Hold option in my Status column.

This Product item detail is in Table so row color formatting apply to my new data entry also.

Please give me steps for conditional formatting.

 

[pecoflyer]

If your Status column is col A, say
Select the entire range, and use =or($a1={"complete";"active";"cancelled";hold}) as CF and format as needed
If you have problems please post a sample sheet
Adapt the array delmiters to your regional settings