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

Hi Mark,
Probably should have pointed you to this to start with
Excel Filters -- Advanced Filter
http://www.contextures.com/xladvfilter01.html

Filters are fun to work with, when you copy and paste from
a filtered list all you pick up is what is not filtered out, and
Mail Merge (MS Word) only see the filtered list.
http://www.mvps.org/dmcritchie/excel/mailmerg.htm
---
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?