ExcelBanter - In Excel is it possible to hide a row condtional upon a cell val..

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - In Excel is it possible to hide a row condtional upon a cell val.. (https://www.excelbanter.com/excel-discussion-misc-queries/31231-excel-possible-hide-row-condtional-upon-cell-val.html)

Louise

In Excel is it possible to hide a row condtional upon a cell val..

In Excel is it possible to hide a row condtional upon a cell value?

paul

with a macro yes,or you could format white text and all values would disapear.
--
paul
remove nospam for email addy!

"Louise" wrote:

In Excel is it possible to hide a row condtional upon a cell value?

Bob the Builder

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?

"paul" wrote:

with a macro yes,or you could format white text and all values would disapear.
--
paul
remove nospam for email addy!

"Louise" wrote:

In Excel is it possible to hide a row condtional upon a cell value?

All times are GMT +1. The time now is 10:39 PM.