Set rng = Selection
For Each cell In rng
If cell.Text = "0" Or cell.Text = "" And _
cell.Offset(0, 3).Value = "hoohah" Then
cell.EntireRow.Interior.ColorIndex = 6
End If
Next


Gord Dibben MS Excel MVP

On Sat, 3 May 2008 11:15:00 -0700, N+ wrote:

hi all !! how can i do the AND , OR function of worksheet
in the vbe ??
ty for helping !!
paolo