validation for a sum that must = 100%

[JR]

In Excell 2002 I have a worksheet where the user can
choose what percent of the time three different procedures
will be followed. The total of the three choices MUST
equal 100.

Is there a way to get the data validation (or some other
non-VBA method) to tell the user his math doesn't add up
to, or goes over, 100?

i.e., using cells 1A, 1B, and 1C as entry cells, cell 1D
must = 100 (using the formula: "=1A+1B+1C" in cell 1D)

Thanks,
JR

 

[Bob Phillips]

JR,

I would use conditional formatting.

Select D1.
Goto menu Format>Conditional Formatting
Set the test to 'Not equal to', the value to 100% or 1
Click Format, select the patter tab, and select a nice colour to highlight
it