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 comeonove...@gmail.com wrote:
Hi,
Can anyone help me with some
Exzcellent guys. Amazing. Thanks.
On Jul 28, 8:18 am, XLS S xlst...@gmail.com 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
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
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 rajanverma1...@gmail.comwrote:
Hope it will Help you
Sub HighLight()
Application.ScreenUpdating = False