Require a cell to be completed based on another cell's value

[Ed Biebel]

I have a worksheet where I would to be able to require a
cell to be completed based on the fact that another cell
in the worksheet is completed.

For instance, if a value is entered into cell 'A1', I
like to require the user to complete cell 'C1'. If
cell 'A2' is completed, I'd like to require the user to
complete cell 'C2'.

Is there an easy way to do this in Excel?

Thanks,


Ed

 

[Paul Corrado]

Any such requirement would be probably very annoying to many of the people
who would use the worksheet. It may be better to use Conditional Formatting
to turn the range red (for example) when an input is required.

In your example, highlight column C and select Format|Conditional Formatting

and use =AND(A1<>"",C1="")

PC