I find just using a cell close to those other cells the best way to tell the
users:

Maybe D3???

=if(sum(a3:c3)<=30,"","Too much in A3:C3!")

I'd format it in big bold red letters.

Elaine wrote:

If A3, B3 and C3 in a sheet add up to over 30 I would like to automatically
warn the user with a message box. Is it possible to put the amount these
three cells add up to as well?

If these cells add up to 30 or less then I don't want anything to happen.

Any help would be appreciated. Thank you.

--Elaine

--

Dave Peterson