conditional formatting - highlight Capital letters but not lower c
in [General]
|
Prev: I want to space my text in a cell at 1.5 or 2 line spacing, dont k
Next: Consolidating multiple workbooks with several tables
From: elaine1 on 24 Mar 2010 05:02 Is there a way to set conditional formatting to just highlight the Capital letters and not the lower case Ie A not a? Thanks
From: Bob Phillips on 24 Mar 2010 05:49 If you mean where there is more in the cell than just the capital letter, no. If the cell would just contain say A, then use =AND(A1<>"",EXACT(A1,UPPER(A1))) -- HTH Bob "elaine1" <elaine1(a)discussions.microsoft.com> wrote in message news:C2B4DD6A-8E72-4F16-B9C7-4761D85F40E3(a)microsoft.com... > Is there a way to set conditional formatting to just highlight the Capital > letters and not the lower case Ie A not a? > > Thanks
From: מיכאל (מיקי) אבידן on 24 Mar 2010 06:07
Assuming the CF is intended for all cells in col. "A" - I would suggest an Event-Macro: ------------------------------------------------------------------------------- Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 1 Then For C = 1 To Len(Target) If Asc(Mid(Target, C, 1)) > 64 And Asc(Mid(Target, C, 1)) < 91 Then Target.Characters(Start:=C, Length:=1).Font.ColorIndex = 3 End If Next End If End Sub ------------- Micky "elaine1" wrote: > Is there a way to set conditional formatting to just highlight the Capital > letters and not the lower case Ie A not a? > > Thanks |