Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Is it possible to conditional format an excel row to auto hide/unhide?

0
Posted

Is it possible to conditional format an excel row to auto hide/unhide?

0

Conditional formatting doesn’t provide an option to hide a row or column. However, you can simulate hidden information using conditional formatting. What I have done is to format the font color white if specific conditions are true. This has the effect of hiding the data from view because a white font on a white cell is invisible. If your cells are colored something else, simply choose that color in your conditional formatting. Another approach is to build a display sheet in conjunction with your data sheet. So instead of manipulating the data sheet itself, a display sheet can use conditions to retrieve only the data you want displayed. This method will be more complex but your results can be very impressive indeed. I can send you an example if you want. Just send me your email address with a link to this posting and I will provide. Otherwise, if you want entire rows or columns to hide, then a macro could do it. Hope this helps! Kind Regards, QwertyKPH @ Yahoo !

What is your question?

*Sadly, we had to bring back ads too. Hopefully more targeted.