Hi,
can't help on the formula's but my own method is to make the cell
background
bright yellow, that way people can see and pick out what they need to fill
in immediately...

Malcolm


"dlmurray" wrote in message
...
I know that you can require a cell/field to be completed in Access, but was
wondering if there was a way to do the same in Excel.