How to validate a list and formula

  • Thread starter Thread starter evillen
  • Start date Start date
E

evillen

Hi

I want to create a Cell data validation that uses a pulldown 'list' of
values AND also restricts the cell value to NOT equal that of another
cell (same row different column).

The formula section would be something like this: NOT(F:F)

Any help gratefully appreciated!

Regards
Len
 
Len,

You're asking for two Data Validation options, List, and Custom. I don't
think you can do that. Well, YOU can, but it won't. There are other ways.
You can cause a list box to appear via an event macro, and use Data
Validation - Custom to build a formula to disallow entries that match column
F. Or the opposite: Use List for the dropdown, and use a macro
(Worksheet_Change event macro) to examine the entry and give the user the
raspberry when they mess up.
 
evillen,

Just a side note. Your reply should be posted as a reply to my reply, not
to your original post. Keeps stuff easier to follow.

Good luck.
 
Back
Top