MS excel 2016 - Microsoft Community

-

i want highlight selected digits of numbers (selected in range) in bold & colour desired user

eg - cell 1 contains 500 & cell 2 contains 5000. user has selected these 2 cells range. wants highlight 50 in these 2 cells( other digits should retain original colour, font etc) in desired colour(say red) & wants them in bold. kindly share suitable formula/macro etc achieve this.

numbers numbers cannot formatted @ character level. numbers strings - cell formatted text - can formatted @ character level, can affect formula results adversely unless formulas rewritten in mind.

you apply conditional formatting cells, using formula option, formula like

=not(iserror(find("50",b2)))

but format entire value , not 50 part of value.



Office / Excel / Windows other / Office 2016



Comments

Post a Comment

Popular posts from this blog

Getting ErrorCode: 120018 when trying to access Microsoft account - Microsoft Community

-
split thread. hi, we 've got user exact same issue: "ce mot de passe été utilisé trop souvent dans le passé. choisissez une chaîne plus difficile à deviner. (which means: " we've seen password many times before. choose harder guess. ") errorcode: 120018 correlationid: 4ab3a486-a11a-4ead-983c-c1c391c3e7d5" it happens when tries update password "login.microsoftonline.com" portal. we tested more 5 different new passwords (passwords never seen before). office 365 synchronized ad; user's account not locked or whatsoever, account set able change password cannot reset it. thanks in advance. ***post moved moderator appropriate forum category.*** hi all,   thanks replies.   generally, password length greater 10 characters. understand users may want have longer passwords. please submit feedback improve our products , services. understandi...
Read more

i need Access database tutorial books recommendations - Microsoft Community

-
hi want recommendations on access books deals table design , table relationship. have been having trouble understanding how pick fields tables when design databases example how figure out fields order , order details tables, see examples , felt have putting many order details in order table. want book or deals comprehensively topic. there tons of great books available, learns differently.  some need read, need see, ... something like https://www.amazon.ca/gp/aw/d/1119074770/ref=mp_s_a_1_2?ie=utf8&qid=1505659406&sr=8-2&pi=ac_sx236_sy340_fmwebp_ql65&keywords=access+visually&dppl=1&dpid=51osglevw8l&ref=plsrch may feet wet. there tons of great websites, like http://www.utteraccess.com/forum/index.php?showtopic=1998783 http://www.accessmvp.com/strive4peace / i'd recommend @ youtube, have done great materials can follow along, pause, replay, on , on until it. ...
Read more

accelorator feature - Microsoft Community

-
accelerator feature not compatible windows 10 causing computer load programs slow,  need download link correct problem moved from: internet explorer / internet explorer 10 / other/unknown hello sharon, starting windows 10, version 1703, accelerator can no longer used in internet explorer. can check article to learn more said setting. let know if have other concerns. regards. Internet Explorer / Internet Explorer 11 / Windows 10
Read more