Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
I have a drop down box (in cell 1) that people have to choose an option for
(out of approx 20 items) - I want to turn the cell next to it (C2) red if one particular option is selected from the drop down menu in C1 - this will act as a reminder that they need to select another option from (C2) in order to proceed - help is needed. Thanks. -- DWillcox |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
Move to cell C2 and click FORMAT/CONDITIONAL FORMATTING in the menu.
Change condition 1 from CELL VALUE IS to FORMULA IS and in field to the right enter the following formula if comparing for a value (substituting your value for the 1 in the example: =B2=1 If you want to compare to a text value, enter the text value in quotes =B2="Message" Then click the FORMAT command button, select the shade of red you prefer and click OK 2 times to return to the worksheet. -- Kevin Backmann "Willco3" wrote: I have a drop down box (in cell 1) that people have to choose an option for (out of approx 20 items) - I want to turn the cell next to it (C2) red if one particular option is selected from the drop down menu in C1 - this will act as a reminder that they need to select another option from (C2) in order to proceed - help is needed. Thanks. -- DWillcox |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
In C2, Conditional Formatting, Formula Is (not Cell Value Is) =C1="whichever
selection you want to shade the cell" Choose the appropriate pattern format. -- David Biddulph "Willco3" wrote in message ... I have a drop down box (in cell 1) that people have to choose an option for (out of approx 20 items) - I want to turn the cell next to it (C2) red if one particular option is selected from the drop down menu in C1 - this will act as a reminder that they need to select another option from (C2) in order to proceed - help is needed. Thanks. -- DWillcox |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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 | Excel Discussion (Misc queries) | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |