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.

hide rows where cell condition is not met
 

Use AutoFilter and hide the rows based on the condition in your helper
column

Regards

Trevor


"amaries" wrote in message
...
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.