ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   can I use conditional formating with result be hiding a row? (https://www.excelbanter.com/excel-discussion-misc-queries/258186-can-i-use-conditional-formating-result-hiding-row.html)

Jean Pierre

can I use conditional formating with result be hiding a row?
 
exemple : if a value is yes then hide the row and if the value is no unhide
the row

Russell Dawson[_2_]

can I use conditional formating with result be hiding a row?
 
Not to my knowledge but you could have the text to format the same colour as
the cells. That way you get a blank row. Not hidden but the data is.
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"Jean Pierre" wrote:

exemple : if a value is yes then hide the row and if the value is no unhide
the row



All times are GMT +1. The time now is 03:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com