Issue with Conditional Formatting

I have built an excel with 12 columns. Column A has a list of available values and depending on the value on Column A, the rest of the 11 columns will be Red or Green based on Conditional Formatting. Now, the first row works great. When I insert a second row, Excel basically copy the colors of the first row and if I change the value on the first row, the color remains unchanged, meaning that the Conditional Formatting is not being applied to the additional Rows. Note that I checked that when inserting a new row, the Conditional Formatting is automatically extended, so the rules should applied to the newly created row. Any idea why Conditional Formatting is not working? Thanks