hide row if cell A>100 and cell B<200 and cell C=300

[dutchdog]

Hi,

Got a quick and easy question I think but cant get it right.

hide row 1, if cell A>100 and cell B<200 and cell C=30

It can only hide row if all 3 variables are met. Guess this is an AND/IF formula but need a quick example.

Thanks

 

[texasalynn]

Try this

If Range("A1")>100 and Range("B1")<200 and Range ("C1")= 300 Then
    Rows("1").Hidden = True
End If

 

[dutchdog]

Try this

If Range("A1")>100 and Range("B1")<200 and Range ("C1")= 300 Then
    Rows("1").Hidden = True
End If

Great stuff.. Just needed a steppingstone for a more complex macro.
Thanks.

Sub HideIfValueAre()
'
' HideIfValuesAre
'

'
 If Range("A1") < 100 And Range("B1") > 200 And Range("C1") = 300 Then
    Rows("11").Hidden = True
End If
End Sub

 

[lenze]

Hi and welcome to the board!!!
Might this be what you are looking for??

Sub Test()
Dim LR As Long
LR = Cells(Rows.Count, "A").End(xlUp).Row
For i = LR To 2 Step -1
If Cells(i, "A") > 100 And Cells(i, "B") < 200 And Cells(i, "C") = 300 Then Rows(i).Hidden = True
Next i
End Sub

lenze