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