View Single Post
  #1   Report Post  
rrucksdashel
 
Posts: n/a
Default How can I get data validation

I want to set up one cell (F41) to contain data validation that verifies that
the entered contents are greater than the contents of another cell (F28).
Since F41 needs to be greater than F28, I also want to make sure that F41
can't have input if F28 is blank. The first part of my validation formula
works fine by itself but the second part doesn't work. Can I combine these
two validation checks in one formula as follows? If not, how should it be
set up if it can be done at all?

=OR(F41F28,CELL("type",F28)<"b")