Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-18-2010, 02:53 AM
Shades Shades is offline Using conditional formatining to change to all caps Windows 7 Using conditional formatining to change to all caps Office 2007
Novice
Using conditional formatining to change to all caps
 
Join Date: Nov 2010
Posts: 1
Shades is on a distinguished road
Post 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?
Reply With Quote
  #2  
Old 11-18-2010, 04:44 AM
Kimberly Kimberly is offline Using conditional formatining to change to all caps Windows 7 Using conditional formatining to change to all caps Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default

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
Reply With Quote
  #3  
Old 05-05-2014, 12:35 AM
sufian,naeem sufian,naeem is offline Using conditional formatining to change to all caps Windows 7 32bit Using conditional formatining to change to all caps Office 2007
Novice
 
Join Date: May 2014
Posts: 2
sufian,naeem is on a distinguished road
Default 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 ?
Reply With Quote
  #4  
Old 05-05-2014, 06:05 AM
macropod's Avatar
macropod macropod is offline Using conditional formatining to change to all caps Windows 7 32bit Using conditional formatining to change to all caps Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
Reply

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
Using conditional formatining to change to all caps 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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:50 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft