View Single Post
  #2  
Old March 21st, 2010, 04:10 PM posted to microsoft.public.excel.worksheet.functions
Dennis Tucker
external usenet poster
 
Posts: 67
Default Conditional Formatting Assistance

I want to understand this better before I help.

You have lots of columns of text. The text in column B is your reference
for the other columns of text.

So if I;
1. looked at the text in cell C1 and
2. compared it to all of the text in column B and
3. there was NOT a match, then I would
4. highlight cell C1 and
5. move on to cell C2

This process would repeat for all cells that have text but do not belong to
column B.

Is this correct?


Dennis




"wendy" wrote in message
...
Hello,

I have a spreadsheet that contains multiple columns containing text. I
would like to highlight the unique values that exist in all other columns
when compared to the values of column B.

Any assistance in accomplishing this would be greatly appreciated.

Thanks