AFAIK, no. But you can black out the rest of the sheet
through conditional formatting and really annoy the user:

1. Select the range on your worksheet that the individual
needs to see / work with etc.
2. Go to Format Conditional Formatting
3. Select "Formula Is" and put:
=AND($A$1="XYZ",$B$1="")
4. Click on the Format radio button and format the
pattern as black.
5. Put this formula in C1:
=IF(AND(A1="XYZ",B1=""),"Please Fill In B1","")
6. Format the font white in C1.

HTH
Jason
Atlanta, GA

-----Original Message-----
Hi

Is there a way I can force a user to make an entry in a
cell without using
macros/code?

EG:
If the result of cell A1 = "XYZ" can I force them to
make an entry in cell
B1. ( If cell A1 = "" then no entry is required in B1).

Hope that makes sense.

Thanks
Steve



.