custom data validation

micfly

Well-known Member
Joined
Sep 8, 2008
Messages
528
How do I express this in a custom formula?


if AmyFinanced="" and R73="Yes" then error alert
 

Some videos you may like

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,503
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
Data validation triggers an error if the formula evaluates to FALSE, so:

=NOT(AND(AmyFinanced="",R73="Yes"))
 

Watch MrExcel Video

Forum statistics

Threads
1,109,000
Messages
5,526,186
Members
409,686
Latest member
Tori83

This Week's Hot Topics

Top