| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
CAN I HIDE ROWS WITH CONDITIONAL FORMATTING?
if a1=0 then hide row
|
|
#2
|
|||
|
|||
|
Hi
no, not possible with conditional formating. It would require VBA -- Regards Frank Kabel Frankfurt, Germany Likepike wrote: if a1=0 then hide row |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting (Date vs Number) | Excel Discussion (Misc queries) | |||
| Why can't I show or hide rows in an outline on a protected sheet? | Excel Discussion (Misc queries) | |||
| conditional formatting blank cell | Excel Discussion (Misc queries) | |||
| conditional formatting | Excel Discussion (Misc queries) | |||
| Adding more than three Conditions to 'Conditional Formatting' | Excel Discussion (Misc queries) | |||
Linear Mode
