How to have an error popup once range cell amount is greater than

[Daniel Bunt]

How do i get an error to pop-up "WARNING: Blah" once a range of cell amounts
reach $200.00

EG: Cell Ranges from D6:O21 Once the total within this rnge of fields have
hit $200 it gives the warning.

Ill probably need... Click on... then press... then type in..... etc steps..

Thankyou

 

[Ken Johnson]

How do i get an error to pop-up "WARNING: Blah" once a range of cell amounts
reach $200.00

EG: Cell Ranges from D6:O21 Once the total within this rnge of fields have
hit $200 it gives the warning.

Ill probably need... Click on... then press... then type in..... etc steps..

Thankyou

Hi Daniel,

You could use data validation.

1. Select the whole sheet by clicking in the little grey box above row
1's label and to the left of column A's label.

2. Click on Data in the main menu bar then click on Validation...
This brings up the Data Validation dialog, which has three tab sheets.

3. In the Allow: box on the Settings tab sheet select Custom.
4. In the Formula: box type this formula...

=SUM($D$6:$O$21)<200

5. Click OK

Try that out, and if you're not happy with the appearance of the error
message you can go back and change it using the other tab sheets on the
Data validation dialog.

Ken Johnson

 

[Dave Peterson]

I'd use a helper cell with a formula:

=if(sum(d621)<200,"","Error! Too much!")

And give it a nice bold, red format.

And put it where it can't be missed.