I would like to know if this is possible and kindly show me how to do it. Here's the thing, I crated an excel inventory and tracking them how long the item remains in my excel. For example, when a certain Item reached its 2nd day, the background color is green then if a certain item last for 3days or more then the row cells color background will turned red.

Please let me know how to do it and kindly give me samples thank you.

I tried conditional formatting but this is not what I wanted, it only turns the background color if a certain cell returned a TRUE value. I wanted for example ROWS A1 to Z1 be highlighted if the item lasted a certain day/s.