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
gt; > ActiveCell.Characters(loc, 3).Font.Bold = True
> > i = i + 3
> > End If
> > Next
>
> > Application.ScreenUpdating = True
>
> > End Sub
>
> > -Original Messag
inal Message-
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> On Behalf Of qcan
> Sent: Thursday, July 28, 2011 3:40 AM
> To: MS EXCEL AND VBA MACROS
> Subject: $$Excel-Macros$$ Formula or macro to find a word that is all
> capitlaiz
e-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of qcan
Sent: Thursday, July 28, 2011 3:40 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Formula or macro to find a word that is all
capitlaized
Hi,
Can anyone help me with some sort of formula
Hi,
Can anyone help me with some sort of formula or Macro that would
identify any word (minmum 3 letters) that is all in caps. I would like
whatever is found to be highlighted in yellow.
Thanks.
--
--
Some important