Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation - Dependent Lists & Conditional Formatting
Using Data Validation, I have created a dependent list (based on instructions
found on the Contextures web site: http://www.contextures.com/xlDataVal02.html). I want to create a conditional format whereby if someone changes the selection in the first data validation list without changing the corresponding selection in the dependent list (i.e., second list), the cell value in the dependent list will turn red. Can anyone tell me how to go about doing this? Thanks, Bob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Manual control of link updating for downloaded quotes? | Excel Discussion (Misc queries) | |||
Data Validation - Using 2 Lists | Excel Discussion (Misc queries) | |||
Dependent List (via Data Validation) Error | Excel Worksheet Functions | |||
Conditional formatting in a data table | Excel Discussion (Misc queries) | |||
How do I use a conditional (IF) statement in Data Validation? | Excel Worksheet Functions |