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.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Part Number[/TD]
[TD]Scrap/Do Not Scrap[/TD]
[TD]Reason[/TD]
[/TR]
[TR]
[TD]123456[/TD]
[TD]Scrap[/TD]
[TD]**Do not need Reason**[/TD]
[/TR]
[TR]
[TD]789123[/TD]
[TD]Do Not Scrap[/TD]
[TD]**Need Reason**[/TD]
[/TR]
[TR]
[TD]456789[/TD]
[TD]Do Not Scrap[/TD]
[TD]**Need Reason**[/TD]
[/TR]
</tbody>[/TABLE]

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.