I am trying to set up a summery page on a excel project I've been
working on.

Basically the way I have the project formatted is that if something
goes under 30% the cell turns yellow as an indicator, and if it goes
under 10% it turns red, as a serious indicator.

I want to try and make a summery sheet that will automatically update
all the red (serious indicator) cells to appear on the summery sheet
as they become red. This will hopefully mean that whoever is using the
page will not have to go looking for red cells, but just look on 1
summery sheet where they will be all detailed.

I don't know if this is even possible, but any ideas or suggestions
will be welcomed.

Thanks,

Niall.