Thread: how do i validate a cell that has a formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
  
Posts: 5,939
Default 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
Reply With QuoteReply With Quote