Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
I have a form that will be filled out by parties from different areas.
I have a drop down list that the user selects the area they are from. At that point I would like to be able to make different input boxes appear or highligh specific boxes for the user to fill out depending on what area they select. If you enter a formatting function into the actual cell to be filled out, it will only work once because the user will overwrite the function the first time the form is used. There has got to be a way to get around this, for example: Could I put a formula in cell A30 that says: =if(A3=Seattle, A5=Yellow, A5=Black) Even though A30 is completely unrelated to the boxes I want adjusted, it would control them if the values were met. Thanks, Ryan |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
No such function exists to enable you to set the format of a cell in
that way. However, you could do it using Conditional Formatting. Select the cells that you want to appear yellow when A3="Seattle", and click on Format | Conditonal Formatting. In the first box you should choose Formula Is rather than Cell Value Is, and then put this formula in the next box: =$A$3="Seattle" Then click on the Format button and on the Patterns tab and choose yellow, then OK your way out. With those cells still highlighted, set a black background colour. Now they will appear black if A3 does not show Seattle, but they will change to yellow when Seattle is chosen. Hope this helps. Pete On Mar 13, 6:38*pm, dicko1 wrote: I have a form that will be filled out by parties from different areas. I have a drop down list that the user selects the area they are from. At that point I would like to be able to make different input boxes appear or highligh specific boxes for the user to fill out depending on what area they select. If you enter a formatting function into the actual cell to be filled out, it will only work once because the user will overwrite the function the first time the form is used. There has got to be a way to get around this, for example: Could I put a formula in cell A30 that says: =if(A3=Seattle, A5=Yellow, A5=Black) Even though A30 is completely unrelated to the boxes I want adjusted, it would control them if the values were met. Thanks, Ryan |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
Use conditional formatting for the individual area based on the value
selected from the drop down. Select the area that is to be filled in by Dept1 Go to conditional formating and use formula A3=Dept1 then set your fill color. Do the same for each Department. "dicko1" wrote: I have a form that will be filled out by parties from different areas. I have a drop down list that the user selects the area they are from. At that point I would like to be able to make different input boxes appear or highligh specific boxes for the user to fill out depending on what area they select. If you enter a formatting function into the actual cell to be filled out, it will only work once because the user will overwrite the function the first time the form is used. There has got to be a way to get around this, for example: Could I put a formula in cell A30 that says: =if(A3=Seattle, A5=Yellow, A5=Black) Even though A30 is completely unrelated to the boxes I want adjusted, it would control them if the values were met. Thanks, Ryan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |