Check if a cell from the same row but different column is empty

You could do this using the Data Validation feature on the Data menu.

• Select F1:F5000
• Select Data\Data Validation
  • Allow: Custom
  • Formula: =A1<>""
  • Configure your message on the Error Alert tab
  • Okay

Hi,

Have followed exactly what you suggested and this doesn't work. The message appears regardless if there are entries in both columns, no entries, one in one column and not the other and so on.

To be more clear sorry, even if there is a value on column A, its stops me from putting a value in Column F, which is shouldn't. Only if there is no value in the same row number in Column A should it stop me putting a value in Column F.

Cheers
Steve

Originally Posted by Stephen Troughton

Hi,

Have followed exactly what you suggested and this doesn't work. The message appears regardless if there are entries in both columns, no entries, one in one column and not the other and so on.

To be more clear sorry, even if there is a value on column A, its stops me from putting a value in Column F, which is shouldn't. Only if there is no value in the same row number in Column A should it stop me putting a value in Column F.

Cheers
Steve

I've tried it and it worked for me. So something is different.

If you selected F1:F5000 by dragging from the bottom up and the active cell was F5000 when you applied the DV formula, then the DV formula doesn't apply properly. Try selecting all of Column F with F1 being the active cell and then re-apply the Data Validation as before.