Validation based on values

[jan]

I need help with a formula.

User "may" enter a value in cells D14, E14, and/or G14.
These cells relate to cell D13, which is a text value and
the cell is labeled "Product A."

Cell d21 contains a formula to sum cells d17:d20. Here is
my problem:

Cells d17:d20 relate to what may be entered in cells d14
or e14 or g14, so if there is no value in any of these
cells (d14, e14, g14), the end user should "Not" enter
values in d17:d20.

To make thing simple, I would like to enter a validation
in cell d21 that if a value is returned based on the sum
formula, but there is no value in cells d14,e14 or g14,
then the user entered data in cells d17:dd20 for the wrong
category (Product A).

How do I write a validation (or conditional formatting) to
tell the end user that they entered data for the wrong
product category?

TIA
Jan

 

[Earl Kiosterud]

Jan,
I didn't follow all of that. You said "if there is no value in any of these
cells (d14, e14, g14)." So can I reduce this to "Disallow entry into
D1720 if any of D14, E14 and G14 are empty?" (Thus, each must have
something in it). If so, select D1720. Data - Validation. Custom:

=AND($D$14<>"",$E$14<>"",$G$14<>"")

Deselect "Ignore blank."

Earl Kiosterud
mvpearl omitthisword at verizon period net