A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Conditional Formatting Assistance



 
 
Thread Tools Display Modes
  #1  
Old March 21st, 2010, 02:38 PM posted to microsoft.public.excel.worksheet.functions
Wendy
external usenet poster
 
Posts: 255
Default Conditional Formatting Assistance

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
  #2  
Old March 21st, 2010, 05: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


  #3  
Old March 21st, 2010, 06:22 PM posted to microsoft.public.excel.worksheet.functions
Rick Rothstein[_2_]
external usenet poster
 
Posts: 2,013
Default Conditional Formatting Assistance

Select all the columns from Column C to the last column you want to have
this functionality (doing this should leave C1 as the active cell) and then
try this Condition Formatting formula on them...

=AND(C1"",NOT(ISNUMBER(MATCH(C1,$B:$B,0))))

--
Rick (MVP - Excel)



"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


  #4  
Old March 21st, 2010, 06:25 PM posted to microsoft.public.excel.worksheet.functions
Bob Phillips[_3_]
external usenet poster
 
Posts: 489
Default Conditional Formatting Assistance

Select all the cells to check, starting with C2, and add CF with a formula
of

=$B2C2

then set the highlight formatting.

--

HTH

Bob

"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



  #5  
Old March 21st, 2010, 06:49 PM posted to microsoft.public.excel.worksheet.functions
Rick Rothstein[_2_]
external usenet poster
 
Posts: 2,013
Default Conditional Formatting Assistance

Just so you know, your original description was not entirely clear as to
what you were looking for. Bob gave you an answer assuming you were looking
to compare values in a row with the contents of the cell for that row in
Column B whereas I assumed you wanted to check each cell against all the
values in Column B (no matter what row). Probably one of our solutions is
the one you are looking for; but we can't say for sure given the terse
description you provided in your original posting.

Anyway, just to follow up on my solution... I assumed your data started in
Row 1 whereas Bob assumed Row 1 was used for headers and that your data
started in Row 2. If, in fact, your data starts in Row 2, then select all
the cells starting with C2 up to a cell including the last column you want
to check down to a row that is larger than the maximum number of rows you
ever expect to fill data into (I'm assuming that is M1000 for this example)
and use this formula instead of the one I posted earlier...

=AND(C2"",NOT(ISNUMBER(MATCH(C2,B:B,0))))

--
Rick (MVP - Excel)



"Rick Rothstein" wrote in message
...
Select all the columns from Column C to the last column you want to have
this functionality (doing this should leave C1 as the active cell) and
then try this Condition Formatting formula on them...

=AND(C1"",NOT(ISNUMBER(MATCH(C1,$B:$B,0))))

--
Rick (MVP - Excel)



"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


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:05 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.