Hi,

I am looking for a scirpt or function that would allow to hide a row based
on a cel value. I looked at some sample macros but not knowledgeable enough
to customize those macros and therefore get an error message. Thanks for any
advise:

I am creating a small project status report. Each row is an action item. As
follow:

# Area Task Action Item Owner %Complete
--------------------------------------------------------------------------
1 Tech Specs Review specs AL 50%
2 Tech Specs Complete p.4 BH <25%

....etc

The %Complete column uses a vailidation list with %100, 50%, <25% values.
All I need is an automatic functions that hides for each a row (=an action
item) if the %complete value is equal to %100.

I am not a macro expert, so I tried some other technics using functions but
unsucessfully.

thanks in advance for any advise.

Sincerly,

G