DATA VALIDATION
 

I'm trying to do data validation on a cell that has a SUM formula. If the
cell sums up all of my monthly expenses I want a warning message to pop up
that tells me I'm spending too much. I don't want to have to key the info
into the cell, I want to leave the SUM formula in the cell and as I spend, it
totals. Once I've hit to high of predetermined number it gives me the error
message.
fdpayne

DATA VALIDATION
 

If your sum is in cell A1, try:

=If(A1somethresholdspendingamount,"You're spending too much","")

This comes in another cell, where you'd like to have it. If you want, format
it in a special color so that it attracts your attention.

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Forrestt" wrote:

I'm trying to do data validation on a cell that has a SUM formula. If the
cell sums up all of my monthly expenses I want a warning message to pop up
that tells me I'm spending too much. I don't want to have to key the info
into the cell, I want to leave the SUM formula in the cell and as I spend, it
totals. Once I've hit to high of predetermined number it gives me the error
message.
fdpayne

DATA VALIDATION
 

In this example, the SUM cell is A11

Select the cells where you'll enter the monthly expenses, e.g. A1:A10
Choose DataValidation
From the Allow drop down, select Custom
In the formula box type: =$A$11<=100
Click on the Error Message tab and enter your message
Click OK


Forrestt wrote:
I'm trying to do data validation on a cell that has a SUM formula. If the
cell sums up all of my monthly expenses I want a warning message to pop up
that tells me I'm spending too much. I don't want to have to key the info
into the cell, I want to leave the SUM formula in the cell and as I spend, it
totals. Once I've hit to high of predetermined number it gives me the error
message.
fdpayne


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com

DATA VALIDATION
 

Better to put a limit on your Visa Card<g


Gord

On Thu, 24 Jul 2008 19:36:25 -0400, Debra Dalgleish
wrote:

In this example, the SUM cell is A11

Select the cells where you'll enter the monthly expenses, e.g. A1:A10
Choose DataValidation
From the Allow drop down, select Custom
In the formula box type: =$A$11<=100
Click on the Error Message tab and enter your message
Click OK


Forrestt wrote:
I'm trying to do data validation on a cell that has a SUM formula. If the
cell sums up all of my monthly expenses I want a warning message to pop up
that tells me I'm spending too much. I don't want to have to key the info
into the cell, I want to leave the SUM formula in the cell and as I spend, it
totals. Once I've hit to high of predetermined number it gives me the error
message.
fdpayne

DATA VALIDATION
 

True, by the time you're entering it in Excel, it's probably too late!

Gord Dibben wrote:
Better to put a limit on your Visa Card<g


Gord

On Thu, 24 Jul 2008 19:36:25 -0400, Debra Dalgleish
wrote:


In this example, the SUM cell is A11

Select the cells where you'll enter the monthly expenses, e.g. A1:A10
Choose DataValidation
From the Allow drop down, select Custom
In the formula box type: =$A$11<=100
Click on the Error Message tab and enter your message
Click OK


Forrestt wrote:

I'm trying to do data validation on a cell that has a SUM formula. If the
cell sums up all of my monthly expenses I want a warning message to pop up
that tells me I'm spending too much. I don't want to have to key the info
into the cell, I want to leave the SUM formula in the cell and as I spend, it
totals. Once I've hit to high of predetermined number it gives me the error
message.
fdpayne




--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com