W wAYNE Mar 1, 2010 #1 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 USE VALIDATION IF THE CELL i WANT VALIDATED HAS A FORMULA. CELL G5 CAN NOT GO OVER 1500. G5 FORMULA IS SUM C2+c3
J Jim Thomlinson Mar 1, 2010 #2 Place your validation on C2 and C3 with a custom validation where the formula is =$C$2+$C$3<=1500
W wAYNE Mar 1, 2010 #3 Also C2 and C3 have formulas is there anyway validation can be used on G5 if theres a formula in it?
D Daryl S Mar 1, 2010 #4 wAYNE - =IF(C2+C3 > 1500,"OVER LIMIT!",C2+C3) You could also add conditional formatting.
J Jim Thomlinson Mar 1, 2010 #5 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...
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...
