Based on a cell value in A1, require a value in B1

[dpc1987]

I have a spreadsheet that I send out to coworkers regarding scrapping obsolete inventory. For example, what I would like to do is to set up the spreadsheet so that based on what they choose in a list, they may or may not be required to add something in the cell next to it. Example below.

Part Number	Scrap/Do Not Scrap	Reason
123456	Scrap	**Do not need Reason**
789123	Do Not Scrap	**Need Reason**
456789	Do Not Scrap	**Need Reason**

<tbody>
</tbody>

So based on the answer "Do not Scrap," I would like for the reason column to have a requirement that they put something in that column.

Thanks in advance!
David

 

[Matt Rogers]

<table border='1' cellspacing='0' cellpadding='2' valign='middle' colspan='4' style='font-family:Calibri; color:#000000; background-color:#FFFFFF; font-size:11px; font-weight:normal; font-style:normal; '><colgroup><col width='28pt'><col width='60pt'><col width='187,5pt'><col width='187,5pt'></colgroup><tr style='background-color:#cacaca'><td> </td><td align='middle'>A</td><td align='middle'>B</td><td align='middle'>C</td></tr><tr><td style='background-color:#cacaca' align='middle'>1</td><td align='middle' >#</td><td align='middle' >Scrap/Do Not Scrap</td><td align='middle' >Reason</td></tr><tr><td style='background-color:#cacaca' align='middle'>2</td><td align='middle' >123</td><td align='middle' >Scrap</td><td align='middle' >**Don't need reaseon**</td></tr><tr><td style='background-color:#cacaca' align='middle'>3</td><td align='middle' >456</td><td align='middle' > </td><td align='middle' > </td></tr><tr><td style='background-color:#cacaca' align='middle'>4</td><td align='middle' >789</td><td align='middle' >Do Not Scrap</td><td align='middle' >**Need reason**</td></tr></table><br><table border='3' cellspacing='0' cellpadding='2' valign='middle' colspan='2' style='table-layout:auto; color:#000000; background-color:#FFFFFF; font-family:Calibri; font-size:10px;'><colgroup><col width='40pt'><col></colgroup><tr style='background-color:#eeaaaa'><td>Cell</td><td>Formula</td></tr><tr><td>C2</td><td><Span style='color:#222222'>=IF</Span><Span style='color:#0000DD'>(B2="","",IF</Span><Span style='color:#222222'>(B2="Scrap","**Don't need reaseon**","**Need reason**")</Span><Span style='color:#0000DD'>)</Span><Span style='color:#222222'></Span></td></tr></table>

 

[dpc1987]

Not exactly. I don't actually want **Do not need reason**, **Need Reason** in column C, I just want to make C4 a required field if "Do not scrap" is chosen in B4.