View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
subdeven subdeven is offline
external usenet poster
 
Posts: 1
Default How do I validate text in a cell based on other sheets in the work

What I am trying to do is check the text in a cell on one sheet to see if it
is the same as the text in any of 4 cells on the last three sheets in the
workbook and issue a warning if it is the same. I can't seem to figure out a
way to do this. Can it be done and if so how?