Need help setting up a conditional rule

[vas1]

Hi all.

I have an excel sheet with Col A and Col B. What I want to do is that I want to prevent the users from typing anything in Col B until they have typed anything in Col A.

eg: If col A is NUMBER and col B is USER,
then USER value should come only if there is a corresponding value in col A in the same row.

Any help is appreciated. Thanks

 

[AlphaFrog]

Hi and welcome.

You could use the Data Validation feature...

• Select column B
• Select from the menu Data\ Validation
  • Allow: Custom
  • Formula: =NOT(ISBLANK(A1))
  • Ignore Blank: unchecked
  • Click on the Error Alert tab and define your alert message.
  • OK