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")

Hi

=AND((F41F28);F28<"")
and uncheck 'Ignore Blank'


--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )




"rrucksdashel" wrote in message
...
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")