Thanks all for your answers.

I'm sure I'll be able to come up with something now.

Many thanks

Steve

"Dave Peterson" wrote in message
...
This won't force the user, but it will make it obvious.

Format C1 in nice bold red letters and put a formula in that cell like:

=if(and(a1="",b1<""),"Please clear B1",if(a1="xyz",b1=""),
"please put something in B1","")
(all one cell)

If xyz just meant anything (not blank), then:
=IF(AND(A1="",B1<""),"Please clear B1",IF(AND(A1<"",B1=""),
"please put something in B1",""))


Steve Jones wrote:

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

--

Dave Peterson