Block entry into a cell if another cell has a value

[Guest]

I am working on a W-4 Federal Tax Form created in Excel. I want to be able to block an entry in one cell (Total number of allowances) if another cell (Write *Exempt* here) has a value, specifically Exempt, in it and vise versa if the cell (Total number of allowances) has a value, specifically a number, in it I want block any entry into the cell (Write *Exempt* here) I hope this makes sense to somebody out there.

 

[Earl Kiosterud]

Old Navy,

You can use Data - Validation. I'll use A1 and B1. Select A1. Data
Validation - Custom:
=B1<>""

If you want to appear a little more refined, you can instead use:
=ISBLANK(B1)

Now do the same with B1, using =A1=""

You can use the error message prompt in Data Validation to supply a genteel
admonishment when the user messes up.

I hope you have nothing to do with those awful Old Navy TV commercials.
Does nothing embarrass those people?

Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

I am working on a W-4 Federal Tax Form created in Excel. I want to be able

to block an entry in one cell (Total number of allowances) if another cell
(Write *Exempt* here) has a value, specifically Exempt, in it and vise versa
if the cell (Total number of allowances) has a value, specifically a number,
in it I want block any entry into the cell (Write *Exempt* here) I hope this
makes sense to somebody out there.