View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Checking cells for value

With data validation perhaps. Assuming the 3 cells in question are A1 - A3,
select them and then

Data|validation|Settings|Custom

and use the formula

=COUNTA(A$1:A$3)<=1

Mike

"T.Lindholm" wrote:

I have three data cells in my table that I need to check for data. If one of
the three cell has data in it, the other two can not be filled with anything,
somekind a pop up should be good too. I hope someone understand what I mean,
and can also help me out.