DATA VALIDATION

[Forrestt]

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]

In this example, the SUM cell is A11

Select the cells where you'll enter the monthly expenses, e.g. A1:A10
Choose Data>Validation
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

 

[Gord Dibben]

Better to put a limit on your Visa Card<g>


Gord

 

[Debra Dalgleish]

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