Frontpage
Forums
Tutorials
Members
Calendar
Subscription
Donate
Links
Contact 
Help
Posted 26 September 2006 - 05:14 PM
I'm currently using Excel 2002 SP3. I use conditional formatting in many of my spreadsheets, but I haven't been able to figure out how to "Hide" a row or column based on a certain condition. Is there a method for doing this already built into Excel's functionality, and if not, is there a way to do it with VBA? Any help would be greatly appreciated! Thank you.
Page 1 of 1
Conditional Formatting to Hide Rows or Columns?
Rate Topic:
Back to top
#2
- Cyber Ops
-
- Group: Super Moderator
- Posts: 3,443
- Joined: 24-September 05
- OS:none specified
-
Country:
Posted 02 October 2006 - 04:28 PM
cpearson is a great resource for this sort of thing and here is their page on color banding. You may be able to adapt it to your needs.
http://www.cpearson....cel/banding.htm
Alternatively, you could also just do a custom sort and exclude the data that you want. That would effectively hide it.
http://www.cpearson....cel/banding.htm
Alternatively, you could also just do a custom sort and exclude the data that you want. That would effectively hide it.
Share this topic:
Page 1 of 1