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