In Excel is it possible to hide a row condtional upon a cell value?
P paul Jun 17, 2005 #2 with a macro yes,or you could format white text and all values would disapear.
B Bob the Builder Jul 22, 2005 #3 The white text makes the text disappear, but not the entire row or column of cells. With a macro, is it possible to make the cells automatically unhide then if the data becomes relevant again due to changes?
The white text makes the text disappear, but not the entire row or column of cells. With a macro, is it possible to make the cells automatically unhide then if the data becomes relevant again due to changes?
