vb script format row color based on cell multiple values

[Muaitai]

Hi,

I am new to this forum as for posting but I follow up on the posts for a long time.
Currently I am working on a spreadsheet where I register deals opportunities, on column I i have a data Validation List of Lost, Won and Invoiced.
What I am trying to do is to change the row color to Red for example to the row where I have Lost and green to the rows where I have Won and Invoiced. Each row goes from column A to N.
I have tried many VB Scripts I found in this forum but I have not been able to achieve what I am looking for.
Thank you in advance.

 

[Momentman]

Have you tried using conditional formatting?

 

[Muaitai]

Yes but I am only able to do it for one condition, when I apply multiple values it does not work on the second value

 

[Momentman]

Yes but I am only able to do it for one condition, when I apply multiple values it does not work on the second value

I don't quite fellow

You should be able to add multiple conditions, for "Lost" , "Won" and "invoiced" if you need to

 

[Muaitai]

When I create the first condition =$I1="Won" it works fine, but when I add a second condition for Invoiced for example, it does not work.