How to make cells automatically change color based on a couple different factors

[Lojinxx]

Hey there everyone,

Attached is a sample manufacturing build plan that I use at work to track how much stock has been or needs to be built. It shows a specific item number on the left and breaks down what I need to have in stock for the upcoming year to meet sales, broken down by month from left to right.

The first tab is a sample of what it's like now. The second tab is what I'd like it to automatically look like.

I'm trying to automate the cells to change colors based on the "Current OnHand" Column as the inventory amount changes, ultimately representing how many months worth of stock I have built.

Any help would be greatly appreciated. Thank you in advance.

[Crooza]

Try these conditional format rules in this order (see attachment too)

=AND(SUM($B5:B5)-B5<$P5,SUM($B5:B5)>$P5) ORANGE and tick stop if true
=SUM($B5:B5)>$P5 RED
=SUM($B5:B5)<=$P5 GREEN

[Lojinxx]

Crooza, thank you very much. This is exactly what I'm looking for. So cool

[Crooza]

Great. Glad it worked. You should show this thread as solved if that addresses your query.