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