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

  • Thread starter Thread starter Dream
  • Start date Start date
D

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
 
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
 
lol don sarky

Atishoo said:
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
Click to expand...
 
Back
Top