Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007-macro programming logic for data validation
Greetings,
I am new to this newsgroup, so nice to meet everyone! I have an Excel dilemma that Id like help with. Id like to apply some macro programming logic to a data validation cell entry, so then when a certain data value is selected in the pull down, the entire row changes color. Here is the algorithm I wish to follow: 1) Launch Excel 2007 2) Go to Data - Data Validation Button - Data Validation in pulldown selection 3) On the Data Validation Window, select the following: a. Allow: List (ignore blank and in-cell dropdown are selected/checked) b. Source: Pass,Fail,Inactive 4) Now here is the fun partwhat I want to do is add macro programming logic, so that the following occurs: a. If Data Validation.Pass is selected, change the font color of all text in the current row to green b. If Data Validation.Fail is selected, change the font color of all text in the current row to red c. If Data Validation.Inactive is selected, change the font color of all text in the current row to grey If someone could help me figure this out, Id be MOST grateful. My email is (derekmegac)(at)(hotmail)(dot)(com) -- Derek Megyesi Senior QA Engineer |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007-macro programming logic for data validation
You can do this without programming by using conditional formatting. If, for
example, A8 contains your data validation dropdown cell: - select row 8 - select Home Conditional Formatting New Rule Use a formula to determine which cells to format - in the text box under the heading "Format value where this formula is true", enter =($A$8="Pass") - click the Format button. On the Font tab, select your shade of green - click OK OK Repeat the steps above to add conditional formatting rules when A8 is Fail or Inactive. Hope this helps, Hutch "Derek Megyesi" wrote: Greetings, I am new to this newsgroup, so nice to meet everyone! I have an Excel dilemma that Id like help with. Id like to apply some macro programming logic to a data validation cell entry, so then when a certain data value is selected in the pull down, the entire row changes color. Here is the algorithm I wish to follow: 1) Launch Excel 2007 2) Go to Data - Data Validation Button - Data Validation in pulldown selection 3) On the Data Validation Window, select the following: a. Allow: List (ignore blank and in-cell dropdown are selected/checked) b. Source: Pass,Fail,Inactive 4) Now here is the fun partwhat I want to do is add macro programming logic, so that the following occurs: a. If Data Validation.Pass is selected, change the font color of all text in the current row to green b. If Data Validation.Fail is selected, change the font color of all text in the current row to red c. If Data Validation.Inactive is selected, change the font color of all text in the current row to grey If someone could help me figure this out, Id be MOST grateful. My email is (derekmegac)(at)(hotmail)(dot)(com) -- Derek Megyesi Senior QA Engineer |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation using dependency logic | Excel Discussion (Misc queries) | |||
Data Validation - Excel 2007 | Excel Worksheet Functions | |||
vba programming in excel 2007 | Excel Discussion (Misc queries) | |||
USING DATA VALIDATION WITH CONDITIONAL LOGIC | Excel Discussion (Misc queries) | |||
Excel VBA/Macro programming for beginners | New Users to Excel |