#1
|
|||
|
|||
Using conditional formatining to change to all caps
I want to make all text entered into a cell uppercase - how can that be done using conditional formating? |
#2
|
|||
|
|||
It can't... uppercase isn't a format, so conditional formatting cannot apply it.
But you can use conditional formatting to draw attention to text that isn't uppercase. Formula is =NOT(EXACT(A1,UPPER(A1))) Or you can use a formula to produce the uppercase of text in other cells. =UPPER(A1) Then copy and paste values to convert the formulas to the values they produced. Or you can use Data validation to forbid anyone from entering text that isn't uppercase. Custom, Formula is =EXACT(A1,UPPER(A1)) Or you can use code to convert text to uppercase. Code:
Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Intersect(Target, Range("A1:A100")) Is Nothing Then Else With Target If UCase(.Text) <> .Text Then .Value = UCase(.Text) End If End With End If End Sub |
#3
|
|||
|
|||
Proper Text Format
What If I want to Capitalize First letters in 2 Cells that are A8 and A10 only
What would be the Macro/Code ? |
#4
|
||||
|
||||
Please don't resurrect old threads - especially when you're posting the same question in a new thread!!!
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Tags |
conditional formatining, uppercase |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Multiple drop caps | Ziggy-R | Publisher | 0 | 10-26-2010 06:23 PM |
Conditional Expression that Moves Data (challenging) | themangoagent | Excel | 1 | 02-20-2010 11:29 AM |
Word not highlighting conditional Merge fields | Dunce | Mail Merge | 0 | 02-15-2010 05:44 AM |
Challenge!! Need help though. (Conditional formatting) | knuckles70 | Excel | 2 | 02-05-2010 12:24 PM |
Conditional Formatting to Hide Rows or Columns? | sczegus | Excel | 0 | 09-26-2006 04:17 PM |