ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   hiding cells with a certian type of formatting (https://www.excelbanter.com/excel-discussion-misc-queries/41822-hiding-cells-certian-type-formatting.html)

Waynef

hiding cells with a certian type of formatting
 
How do I get excel to hide cells that has not been formatted in a row or
colum that I applied a format condition to.?

Excel_Geek


just for clarification...do you want the entire cell row or column to be
hidden, or do you want the text color of the contents of just that cell
to be changed to WHITE or whatever color would hide it given its fill
color?


--
Excel_Geek


------------------------------------------------------------------------
Excel_Geek's Profile: http://www.excelforum.com/member.php...o&userid=26423
View this thread: http://www.excelforum.com/showthread...hreadid=398280



All times are GMT +1. The time now is 12:38 AM.

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