help with IF cell meets certain condition..then do the following

[Dream]

Hi all,

how to do the following with IF statements, how to type them instead of the
conditional formatting feature

1- IF a cell meets a certain condition, then change its color?
2- IF a cell meets a certain condition, then change the color of row it
falls in?
3- IF a cell meets a certain condition, then delete the row the cell falls in?

Thanks in advance

 

[Don Guillett]

Homework?

 

[Atishoo]

The If excell Function only returns values as an output if a given statement
is true or false.
To do what you propose I think you will have to use the visual basic editor
(alt f11)

the following will change text in a1 to green if its value is 10 as an example
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Range("a1").Value = 10 Then
Range("A1").Font.Color = _
RGB(0, 255, 0)
End If
End Sub

 

[Atishoo]

lol don sarky

The If excell Function only returns values as an output if a given statement
is true or false.
To do what you propose I think you will have to use the visual basic editor
(alt f11)

the following will change text in a1 to green if its value is 10 as an example
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Range("a1").Value = 10 Then
Range("A1").Font.Color = _
RGB(0, 255, 0)
End If
End Sub