View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
HotRod HotRod is offline
external usenet poster
 
Posts: 147
Default If Cell1 has something Cell2 is blank?

I have 6 Cells S,T,U,V,W & X and I only want to allow the user to put an "X"
in one of them in that row. How can I write a "IF" so that only one of the
6 cells contains a "X"