LinkBack URL
About LinkBacks
I am trying to use =UPPER(A1) as a conditional Format, but it isn't taking. What am I missing?
Also, is there a number to how many conditions a cell/sheet can have?
Thank you for assistance!
I am trying to use =UPPER(A1) as a conditional Format, but it isn't taking. What am I missing?
Also, is there a number to how many conditions a cell/sheet can have?
Thank you for assistance!
Last edited by tacnola; 09-23-2019 at 03:45 PM.
Do you want to see if everything in cell is in uppercases or just the first letter? If so, use proper function.
Also, is bad practice to add as many CF conditions as possible. Keep it simple, and check if same rule can be applied to multiple ranges
Click the * to say thanks.
You have to compare that value with something else, and you probably need to use the EXACT function.
You can have up to 64 different conditional formats per cell (though what would you need that many for?)
Hope this helps.
Pete
So the cell(s) are open and fillable cell(s). So if someone enters a "n" I want it to changed to "N".
I can't have a formula in the cell, since it is a fillable cell. So I was hoping I would set it up as a Conditional Formatting event.
You will either need VBA to do it automatically or data validation restrictions in order to make the user enter them as you want. Or are you plan to highlight them and then to change each one manually?
oh well shucks. I don't in my case a VBA will work.
Thank you for your response!!
If not vba Data validation.
Select A2:A8
Data -> Data Validation
Allow -> Custom
Formula
=FIND(UPPER(A2),A2)=1
Input message -> Full text entry should be in upper case only.
OK
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
The following event code procedure will automatically make any entry into cell A1 upper case...Originally Posted by tacnola
HOW TO INSTALL Event Code
Please Login or Register to view this content.
------------------------------------
If you are new to event code procedures, they are easy to install. To install it, right-click the name tab at the bottom of the worksheet that is to have the functionality to be provided by the event code and select "View Code" from the popup menu that appears. This will open up the code window for that worksheet. Copy/Paste the event code into that code window. That's it... the code will now operate automatically when its particular event procedure is raised by an action you take on the worksheet itself. Note... if you are using XL2007 or above, make sure you save your file as an "Excel Macro-Enabled Workbook (*.xlsm) and answer the "do you want to enable macros" question as "yes" or "OK" (depending on the button label for your version of Excel) the next time you open your workbook.
[QUOTE=Rick Rothstein;5198088]The following event code procedure will automatically make any entry into cell A1 upper case...
So, This worked perfectly when applying it to a single cell (C5) but when I tried to expand the fields from the single cell, "C5", to the entire area, C5:AG100, then it doesn't work at all. Any guidance?Please Login or Register to view this content.
Also...I am getting a "RUN-TIME error '13': Type Mismatch....
Thank you again for your responses!!Please Login or Register to view this content.
Last edited by tacnola; 09-23-2019 at 11:06 AM. Reason: To add an error I'm getting
For a range of cells, use this Change event instead of the one I gave you earlier...
Please Login or Register to view this content.
Thank you!! Worked Perfectly!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks