VIRTUOSI
GOITROUS
RISOLUTO
SUMOTORI
TIMOROUS
TORTIOUS
VIRTUOSO
RUCTIOUS
POURSUIT
TURQUOIS
VIRTUOUS
POTOROOS
OUTDOORS
OUTROOPS
OUTROOTS
TUMOROUS
OUTPOURS
TORTUOUS
I have this on a1 , i want conditional formatting to highlight first 7 letters that are same , thus it should highlight virtouso and virtousi
Length of all letters are 8 characters
What would be an equivalent next conditional formatting if I were to use length of characters being 7 characters where first 6 characters are same ?
You cannot use CF to conditionally format part of a cell. You will need VBA for this.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Conditional formatting has thingi called rule , maybe it can allow that , not sure
Yes, I know how it works and I am sure. You cannot use it to conditionally format part of cell. You will need VBA for that.
Okay AliGW , got you
Are you able to shift this thread to VBA , through your magic fingers
Shall I move this to the VBA section?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks