Hi D.,
or a filter to hide the rows, and the formulas work the same
as for Conditional Formatting the object is to produce True or
False (or the equivalent).

Some information on Filters:
http://www.datapigtechnologies.com/ExcelMain.htm flash presentations
http://www.contextures.com/tiptech.html look for fitler

Please post a real question in the text body, as you can probably
see the text of your subject was truncated which makes question
even more ambiguous. Leaving the text body empty is confusing
and more frequently than not results in very ambiguous questions
by those who won't take the time to ask a proper question. For
instance if you already know about filters that is not conveyed.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Bernard Liengme" wrote in message ...
A formula cannot change the appearance of a cell
You could use Format |Conditional Formatting to give the cells in the row a
font colour the same as the background so as to be invisible.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"DNelson" wrote in message
...