ExcelBanter - Data Validation

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Data Validation (https://www.excelbanter.com/excel-worksheet-functions/63419-data-validation.html)

SMusial

Data Validation

I want to prevent input into a cell unless another cell has a value in it.

JulieD

Data Validation

Hi

Assuming the cell that you want to ensure has something in it before
allowing entry in the other cell is D8,
then in the other cell
- choose data / validation
- choose custom
- in the formula line type
=D8<""

- uncheck the "IGNORE BLANK" box
- click on the OK button

--
Cheers
JulieD

julied_ng at hctsReMoVeThIs dot net dot au

"SMusial" wrote:

I want to prevent input into a cell unless another cell has a value in it.

All times are GMT +1. The time now is 06:11 AM.