Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting based on Upper case
How do I conditional format only text that is upper case?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting based on Upper case
You can't if you mean highlight parts of a string in the same cell, if
strings in cells are all upper or something else you can use =EXACT(UPPER(A1),A1) -- Regards, Peo Sjoblom http://nwexcelsolutions.com "cs_vision" wrote in message ... How do I conditional format only text that is upper case? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting based on Upper case
This is how the cell looks"
BUFFENS, Delle - or BUFFENS, Delle R. - I wanted to highlight the entire cell "Peo Sjoblom" wrote: You can't if you mean highlight parts of a string in the same cell, if strings in cells are all upper or something else you can use =EXACT(UPPER(A1),A1) -- Regards, Peo Sjoblom http://nwexcelsolutions.com "cs_vision" wrote in message ... How do I conditional format only text that is upper case? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting based on Upper case
You need to give us more examples assuming that those 2 should be
highlighted what about an example that is not highlighted? Is it always the first word that is upper as opposed to something like Delle, BUFFENS ? Peo "cs_vision" wrote in message ... This is how the cell looks" BUFFENS, Delle - or BUFFENS, Delle R. - I wanted to highlight the entire cell "Peo Sjoblom" wrote: You can't if you mean highlight parts of a string in the same cell, if strings in cells are all upper or something else you can use =EXACT(UPPER(A1),A1) -- Regards, Peo Sjoblom http://nwexcelsolutions.com "cs_vision" wrote in message ... How do I conditional format only text that is upper case? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting based on Upper case
Here an example. I only wanted the name highlighted, the hypen is okay to
LEUSER, Rudolf - will dec. trust trust rest. living will p/atty. - prop. p/atty. - h.c. durable p/atty designa. of h/c surrogate Michigan durable p/atty Michigan designa. of patient advocate "Peo Sjoblom" wrote: You need to give us more examples assuming that those 2 should be highlighted what about an example that is not highlighted? Is it always the first word that is upper as opposed to something like Delle, BUFFENS ? Peo "cs_vision" wrote in message ... This is how the cell looks" BUFFENS, Delle - or BUFFENS, Delle R. - I wanted to highlight the entire cell "Peo Sjoblom" wrote: You can't if you mean highlight parts of a string in the same cell, if strings in cells are all upper or something else you can use =EXACT(UPPER(A1),A1) -- Regards, Peo Sjoblom http://nwexcelsolutions.com "cs_vision" wrote in message ... How do I conditional format only text that is upper case? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting based on Upper case
Not really a good solution but it might catch most of them
=EXACT(UPPER(LEFT(A1,FIND(",",A1)-1)),LEFT(A1,FIND(",",A1)-1)) assuming that the format of a name is always the same with all caps last name, comma and first name of course if the comma is unique to the each occurrence of an all caps name then you could use =ISNUMBER(FIND(",",A1)) -- Regards, Peo Sjoblom http://nwexcelsolutions.com "cs_vision" wrote in message ... Here an example. I only wanted the name highlighted, the hypen is okay to LEUSER, Rudolf - will dec. trust trust rest. living will p/atty. - prop. p/atty. - h.c. durable p/atty designa. of h/c surrogate Michigan durable p/atty Michigan designa. of patient advocate "Peo Sjoblom" wrote: You need to give us more examples assuming that those 2 should be highlighted what about an example that is not highlighted? Is it always the first word that is upper as opposed to something like Delle, BUFFENS ? Peo "cs_vision" wrote in message ... This is how the cell looks" BUFFENS, Delle - or BUFFENS, Delle R. - I wanted to highlight the entire cell "Peo Sjoblom" wrote: You can't if you mean highlight parts of a string in the same cell, if strings in cells are all upper or something else you can use =EXACT(UPPER(A1),A1) -- Regards, Peo Sjoblom http://nwexcelsolutions.com "cs_vision" wrote in message ... How do I conditional format only text that is upper case? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conversion of Numercials to Figure | Excel Worksheet Functions | |||
case sensitive conditional formatting | Excel Worksheet Functions | |||
Loop for VBA code? | Excel Worksheet Functions | |||
Select Case Conditional Formatting Sub? | Excel Discussion (Misc queries) | |||
Convert Numeric into Text | Excel Worksheet Functions |