Conditional Formatting - Numerical String ending with Alphabetical Value
Hey all, I am working with a somewhat lengthy worksheet with over 60,000 records. oOne of the columns within the worksheet is the "Account Number" column, which typically consists of 14 numerical characters, but can sometimes have additional or fewer characters. I need to set up a conditional format to pick up any account number that ends in an alphabetical value, (e.g. a through z). The account number is located in column G. Many Thanks!
1) Highlight G2:G6000
2) Apply this Conditional Formatting:
Rule1 - Formula - =NOT(ISNUMBER(RIGHT(G2,1)+0))
Format - Fill - Red
http://screencast.com/t/l4OfQ9UPFNec
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
try this in CF...
=AND(CODE(RIGHT(C5,1))>=65,CODE(RIGHT(C5,1))<=122)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Perfect! Many Thanks JB!
Tried it but didn't have much luck. JB's response worked like a charm. Thanks for the response, however. It is very appreciated.Originally Posted by FDibbins
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks