This could be a formula for conditional formatting, building a form that some cells are required to have an input before advancing to the next that requires input. Is it possible to prevent the user from moving to the next cell if the previous cell requiring input is left blank? Example, cell AD1 has a list, before the user can move to the next cell AD2 they must complete entry from the list in AD1.
Help.
Help.