Hi Mark,
Not with Conditional Formatting, but you can use Auto Filter
and the formulas just like Conditional Formatting are
Worksheet Functions that return either True or False.
See Debra Dalgleish's site contextures.com
Excel Filters -- Advanced Filter -- Complex Criteria
http://www.contextures.com/xladvfilter02.html
---
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
"mark_b2410" wrote in message ...
This isn't help but...
Can you hide rows/cells using conditional formatting?
If so, how?
Thanks
mark
--
mark_b2410
------------------------------------------------------------------------
mark_b2410's Profile: http://www.excelforum.com/member.php...o&userid=16848
View this thread: http://www.excelforum.com/showthread...hreadid=320382