DATA VALIDATION

  • Thread starter Thread starter Forrestt
  • Start date Start date
F

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
 
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
 
Back
Top