Can you conditionally hide a cell?

I want to use an IF command to hide a cell if it has no value as a way of consolidating my list. I've tried conditional formating but can't find a "hide" selection. Can it be written in code? Any suggestions would be appreciated.

[Paul B]

You can't "Hide" a cell with conditional formatting, but you could change the font color to your sheet color if you don't want to see it.

[Bruno]

Yes, almost everything is possible...
if you use vba

Use this code and if the entire row is empty, it will be hidden.

Private Sub Worksheet_Change(ByVal Target As Excel.Range)

If Target = "" Then
    Rows(Target.Row).Select
    If Application.CountA(Selection) = 0 Then
    Selection.EntireRow.Hidden = True
    End If
End If

End Sub

[sho-nuff]

Thank you Bruno, but the rows that I want hidden have "0" values in them. Your code is not working to hide them. I still get something like this:

Market Analysis
0
Advertising
0
0
Sales
Etc.

If you can help me with this I would appreciate it very much.

[sho-nuff]

Perhaps my probelem with your code lies in the covnersion. I keep getting an error with this line:

If Target = "A1:A125" Then

I'm pretty sure it's because of the target values but not sure how to correct. Please advise.

[Juan Pablo González]

This should read

If Target.Address = "$A$1:$A$125" then

[sho-nuff]

Thank you for your help, but the rows are still present after intering the VBA code.
Any suggestions?

[anno]

just a thought - have you checked that all the cells in the rows are actually empty?
another thought - not sure if this would affect anything, but do you have any merged rows or columns in the target range?

[ This Message was edited by: anno on 2002-02-20 19:27 ]

[Bruno]

There was something wrong with the previous posting...
(Juan, you may delete it ?)

On 2002-02-20 11:25, sho-nuff wrote:
Thank you Bruno, but the rows that I want hidden have "0" values in them. Your code is not working to hide them. I still get something like this:

Market Analysis
0
Advertising
0
0
Sales
Etc.

If you can help me with this I would appreciate it very much.

Try something like this if you want to hide the cells with "0" and the empty cells and if you only want to check the changed cell :

This code doesn't check other columns.

Private Sub Worksheet_Change(ByVal Target As Excel.Range)

If Target = "" Then
    Rows(Target.Row).EntireRow.Hidden = True
ElseIf IsNumeric(Target) Then
    If Target.Value = 0 Then
        Rows(Target.Row).EntireRow.Hidden = True
    End If
End If

End Sub

[ This Message was edited by: Bruno on 2002-02-21 02:22 ]

[sho-nuff]

now I'm getting a script error with my target line:

If Target = "$A$1:$A$125" Then

Need I broaden the range or narrow it?