View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
charts for fun charts for fun is offline
external usenet poster
 
Posts: 1
Default conditional formate

Is it possible to have a group of cells, say columns A through E and rows 1
to 15 filled with number values become hightlighted if on the same spread
sheet, they match entries a row of cells where numbers entered match? My idea
is to populate a series of cells one at a time with numbers, and as they are
entered, if they occur elsewhere in the original group, they become
highlighted.