Hi there everyone,
Happy Monday to those of you that have reached it.
I just want to know if it is possible to hide a complete row using conditional formatting or maybe a specific formula. So if a condition is met within a single cell, then I would like the whole row to be hidden from view?
Hope that make sense, thanking you in advance.
Cheers
Short answer - no, it is not possible to hide a row with any formula (in a cell or from CF), you would need VBA for that
At best, you could make all teh data in that row to appear not to be there by setting the forground and background color to the same
Or, you could change your formulas to show nothing if certain criteria are not met.
However, in both of teh above, the entire row will still be there and be visible, it will just appear to not have anything in it
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I thought as much but I wasn't 100%.
Your help is much appreciated.
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks