help with IF cell meets certain condition..then do the following
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 |
help with IF cell meets certain condition..then do the following
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 |
help with IF cell meets certain condition..then do the following
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 |
help with IF cell meets certain condition..then do the followi
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 |
All times are GMT +1. The time now is 10:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com