View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lindsay Lindsay is offline
external usenet poster
 
Posts: 21
Default highlight dependent cells

Hello,

I'm having trouble explaining my question, so I've come up with a simple
example.
Column C Column D
horse cat
cow dog
pig
cat
owl
dog

I would like the entries in Column C to highlight, if they match an entry in
Column D. In this case, C5 (cat) and C7 (dog) would highlight....is this
possible? Thanks so much!