View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nick nick is offline
external usenet poster
 
Posts: 192
Default Comparing data in columns

Ok, so I understand conditional formatting basics, but this seems over my head.

I want to highlight the row of data if the following parameters are met

Col C (names) Col E (usernames)

If rowXCol C matches rowYCol C AND NOT rowxCol E matches rowyCol E then
Highlight rows x and y

I would like to be able to compare rowXColC to the entire column C to find
matches, but rowXColE only needs to search the rows that match in ColC

Does this make sense?

Thanks in advance.