Posted to microsoft.public.excel.programming

Cath[_2_]

external usenet poster

Posts: 1

Validating a Formula

I am trying to validate a cell that has a formula in it.

i.e. c132=sumc1:c131

i need to have an error message appear in the sum of c132
is greater than 65. i can get the validation to work on a
cell that has a number entered directly but cannot get it
to work on a cell that has a formula.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Validating cells	[email protected]	Excel Discussion (Misc queries)	1	October 30th 08 12:53 AM
validating	Philashley	Excel Discussion (Misc queries)	2	March 13th 08 03:54 PM
data validation: formula for validating only multiples of 10	Excelnovice	Excel Worksheet Functions	3	May 15th 06 07:17 PM
validating	Ayesha	Excel Worksheet Functions	2	April 26th 06 02:56 PM
Validating	Sdbenn90	Excel Discussion (Misc queries)	0	March 27th 06 12:05 AM

All times are GMT +1. The time now is 10:56 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us