Calculate certain cells

[mcm2010]

I thank you all in advance!

I'm trying to color a cell in regards to circumstances.

Item A1 max value should be 3000, if reaching 3000 or more, highlighted red.

Item A2 minus A1, should act the same too. If A2 minus A1, were 3000 or more, A2 should be highlighted red.

If it weren't, move on to the next, and see if A3 minus A2 was 3000+ or not and highlight.

Seems like I just need an IF loop for this, but not quite sure how to format it correctly.

I thank you in advance!

 

[villy]

In Conditional Formatting:

While A1 is selected format it as CellValueIs greater than or equal to 3000 then highlight by red
From A2 onwards...
FormulaIs =sum(A2-A1)>3000 then highlight by red

 

[mcm2010]

I thank you. I'll certainly start there and see how well it goes!