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

Homework?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Dream" wrote in message
...
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
"Dream" wrote:

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

lol don sarky

"Atishoo" wrote:

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
"Dream" wrote:

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