Thread: How can you use data validation for a cell with a formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Floyd Floyd is offline
external usenet poster
  
Posts: 7
Default How can you use data validation for a cell with a formula
I have this cell with a formula = SUM(IF(frequency(A13:A20,A13:A20)0,1 and I
want to give the user an error message if the calculation exceeds 15.
A13-A20 are date entries and those cells needs a data validation also. Can
one cell have 2 data validations? or yet, can this cell with a formula have
data validation?
Reply With QuoteReply With Quote