excel fields - validation

  • Thread starter Thread starter magix
  • Start date Start date
M

magix

How can I use excel formula to force an entry to be input to Field B, if
Field A has certain value ?

Thanks.

Regards.
 
Use conditional formatting to turn the Field B red if A has a value and B is
empty.

Eg:
=AND($A$1<>"",$B$1="")

Assuming you mean on a sheet - you don't specify.

Tim
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A data validation question 1
Excel Concatenate Form Name to Parse for function 1
Excel How to get the number of days an item was opened from the today's date. 14
Conditional Validation In Excel 1
IF(AND(Complex Formula in Error in data import before I process it 8
Excel VBA Replace Data Validation Titles and Input Messages 2
Data validation list drop-down values based on prior selections 2
excel form populating in access 2002-03 but not 2007 8

Back
Top