View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default compulsory/madatory cell

I know of no regular feature in Excel to do that, but I have home-brewed a
scheme in the past that used Conditional Formatting to color cells red until
they have data entered in them...........

hth
Vaya con Dios,
Chuck, CABGx3



"sedonovan" wrote:

is there a way to make sure that a user fills in all cells in a row, if for
example a1 has been populated? - with data validation you can choose not
ignore blank cell, but the inputs into can simply be overlooked!

thanks in advance!
:)