Re: $$Excel-Macros$$ Formula or macro to find a word that is all capitlaized

Hi Try : Use below formula in Conditional Formatting =SUM(LEN(A1)-LEN(SUBSTITUTE(A1,CHAR(ROW(INDIRECT("65:90"))),"")))=3 Reference :http://dmcritchie.mvps.org/excel/strings.htm Thanks Mahesh On Thu, Jul 28, 2011 at 3:39 AM, qcan wrote: > Hi, > > Can anyone help me with some sort of formula

Re: $$Excel-Macros$$ Formula or macro to find a word that is all capitlaized

Exzcellent guys. Amazing. Thanks. On Jul 28, 8:18 am, XLS S wrote: > Hey Ranjan qcan want if cell contain any 3 Capital letter then color hole > cell.but your solution color only first 3 letter ... > > On Thu, Jul 28, 2011 at 5:32 PM, Rajan_Verma wrote: > > > > > > > Hope it will

Re: $$Excel-Macros$$ Formula or macro to find a word that is all capitlaized

Hey Ranjan qcan want if cell contain any 3 Capital letter then color hole cell.but your solution color only first 3 letter ... On Thu, Jul 28, 2011 at 5:32 PM, Rajan_Verma wrote: > Hope it will Help you > > Sub HighLight() > > Application.ScreenUpdating = False > On Error Resume N

RE: $$Excel-Macros$$ Formula or macro to find a word that is all capitlaized

Hope it will Help you Sub HighLight() Application.ScreenUpdating = False On Error Resume Next Dim cell As Range Dim rng As Range Dim st As String Dim loc As Integer Dim n as string st = "" Set rng = ActiveSheet.UsedRange For Each cell In rng