There must be some condition that triggers the red cells, so just create a
formula on the summary sheet that checks that same condition and outputs the
result if true.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Niall 84" wrote in message
...
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.