View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
FARAZ QURESHI FARAZ QURESHI is offline
external usenet poster
 
Posts: 553
Default CONDITIONAL FORMATTING

Any formula, for how to have a wrong name be highlighted if it doesn't
pertain to a list of 50 different branches? List is already made up in sheet2
and the array being named "Branches". Except Data validation check of LIST.
One can after all paste value in case of a data validation too.