how do i validate a cell that has a formula
 

HOW DO i USE VALIDATION IF THE CELL i WANT VALIDATED HAS A FORMULA. CELL G5
CAN NOT GO OVER 1500. G5 FORMULA IS SUM C2+c3

how do i validate a cell that has a formula
 

Place your validation on C2 and C3 with a custom validation where the formula
is
=$C$2+$C$3<=1500
--
HTH...

Jim Thomlinson


"wAYNE" wrote:

HOW DO i USE VALIDATION IF THE CELL i WANT VALIDATED HAS A FORMULA. CELL G5
CAN NOT GO OVER 1500. G5 FORMULA IS SUM C2+c3

how do i validate a cell that has a formula
 

Also C2 and C3 have formulas is there anyway validation can be used on G5 if
theres a formula in it?

"Jim Thomlinson" wrote:

Place your validation on C2 and C3 with a custom validation where the formula
is
=$C$2+$C$3<=1500
--
HTH...

Jim Thomlinson


"wAYNE" wrote:

HOW DO i USE VALIDATION IF THE CELL i WANT VALIDATED HAS A FORMULA. CELL G5
CAN NOT GO OVER 1500. G5 FORMULA IS SUM C2+c3

how do i validate a cell that has a formula
 

wAYNE -

=IF(C2+C3 1500,"OVER LIMIT!",C2+C3)

You could also add conditional formatting.
--
Daryl S


"wAYNE" wrote:

HOW DO i USE VALIDATION IF THE CELL i WANT VALIDATED HAS A FORMULA. CELL G5
CAN NOT GO OVER 1500. G5 FORMULA IS SUM C2+c3

how do i validate a cell that has a formula
 

Validation must be on the precidents of the formula and not on the formula
itself. Go to the precidents of the formula in C2 and C3 and validate on
those...
--
HTH...

Jim Thomlinson


"wAYNE" wrote:

Also C2 and C3 have formulas is there anyway validation can be used on G5 if
theres a formula in it?

"Jim Thomlinson" wrote:

Place your validation on C2 and C3 with a custom validation where the formula
is
=$C$2+$C$3<=1500
--
HTH...

Jim Thomlinson


"wAYNE" wrote:

HOW DO i USE VALIDATION IF THE CELL i WANT VALIDATED HAS A FORMULA. CELL G5
CAN NOT GO OVER 1500. G5 FORMULA IS SUM C2+c3