View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
cs_vision
 
Posts: n/a
Default 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?