Example for forum.xlsx

In the example I gave that would be true,

However for the actual requirements are not exact,

as in it goes from 12 to 25, then to 72.
where another category goes from 24 to 40 then to 80

Ah why am i being so paranoid,

Here is the way its set up. (see attachment)

The bottom numbers would reference totals from another page and automatically roll up.
However right now I have them as basic so as to test the conditional formatting.