LinkBack URL
About LinkBacks
Does anyone know how I would highlight a cell in conditional formatting if for instance the 6th character in a cell is a number five or if the first five characters in the cell start "ABCDE"?
Many thanks guys
Highlight a cell if the nth character is a certain number/text or starts with text
Does anyone know how I would highlight a cell in conditional formatting if for instance the 6th character in a cell is a number five or if the first five characters in the cell start "ABCDE"?
Many thanks guys
i think you would need to do two CF's
Formula =LEFT(A1,5)="ABCDE"
formula =MID(A1,6,1)="5"
Last edited by humdingaling; 04-01-2015 at 03:34 AM. Reason: Oops...change the mid to 6 instead of 5
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
=MID(K1,6,1)="5"
=MID(K2,1,5)="abcde"
or in one CF rule...
=OR(MID(A1,6,1)="5",LEFT(A1,5)="ABCDE")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Great, thanks everyone.
Glad to have helped! If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks