W
wAYNE
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
CAN NOT GO OVER 1500. G5 FORMULA IS SUM C2+c3
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jim Thomlinson
Place your validation on C2 and C3 with a custom validation where the formula
is
=$C$2+$C$3<=1500
is
=$C$2+$C$3<=1500
W
wAYNE
Also C2 and C3 have formulas is there anyway validation can be used on G5 if
theres a formula in it?
theres a formula in it?
D
Daryl S
wAYNE -
=IF(C2+C3 > 1500,"OVER LIMIT!",C2+C3)
You could also add conditional formatting.
=IF(C2+C3 > 1500,"OVER LIMIT!",C2+C3)
You could also add conditional formatting.
J
Jim Thomlinson
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...
itself. Go to the precidents of the formula in C2 and C3 and validate on
those...