ExcelBanter - CAN I HIDE ROWS WITH CONDITIONAL FORMATTING?

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

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

- - CAN I HIDE ROWS WITH CONDITIONAL FORMATTING? (https://www.excelbanter.com/excel-discussion-misc-queries/2305-can-i-hide-rows-conditional-formatting.html)

Likepike

CAN I HIDE ROWS WITH CONDITIONAL FORMATTING?

if a1=0 then hide row

Frank Kabel

Hi
no, not possible with conditional formating. It would require VBA

--
Regards
Frank Kabel
Frankfurt, Germany

Likepike wrote:
if a1=0 then hide row

Dave Peterson

You may want to look at Data|filter|autofilter

Then you can show rows that are not equal to 0.

Likepike wrote:

if a1=0 then hide row

--

Dave Peterson

All times are GMT +1. The time now is 07:57 AM.