| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
hide rows where cell condition is not met
How can hide rows where a cell condition is not met? ie, If two cells (same
row) are not equal, hide the row. Otherwise I have put a formula that compares the two cells and returns TRUE or FALSE. I want to hide the TRUEs not delete and I don't want to sort the sheet based on this result. I just want to hide/display. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data: select a cell x rows below the current, where x is designate | Excel Discussion (Misc queries) | |||
| Rows to drop off (hide) when a value is entered into a cell | Excel Discussion (Misc queries) | |||
| Can I hide rows in Excel 2002 using a formula in a cell? | Excel Discussion (Misc queries) | |||
| enhanced conditional formatting | Excel Discussion (Misc queries) | |||
| How can I get a cell locked if the condition is false? | Excel Worksheet Functions | |||
Threaded Mode
