excel - Conditional Formatting and text: Based on a condition I want to copy the format of another cell -

-

in excel

i trying copy elements , cell format of cell based on condition.

g12 = (if c10 = c11, *leave blank, if (c10>c11, *copy elements , format of b10, *copy elements , format of b11))

i've tried function , have had success copying elements, cannot formatting change well. used:

=if($c$10=$c$11,"",if($c$10>$c$11,b10,b11))

i learned conditional formatting don't see way copy format of cell based on condtion. color has specified.

thanks help!

tl:dr

march madness example

virginia beat unc 76 75

i want copy copy (1) virginia next spot in bracket lime green background. had unc won, want (16) unc , rose color copy next bracket spot

go vb-editor (alt + f11), insert new module , paste code:

function rangeselectionprompt(txt string) range     dim rng range     set rng = application.inputbox(txt, "select range", type:=8)      set rangeselectionprompt = rng end function  sub formatas()      dim sh worksheet     dim r1 range, r2 range     dim txt1 string, txt2 string     dim cel range, col range     dim val, check long, pos long      set sh = activesheet      txt1 = "enter range #1 - sourse"     txt2 = "enter range #2 - paste formats"      set r1 = intersect(rangeselectionprompt(txt1), sh.usedrange)     set r2 = intersect(rangeselectionprompt(txt1), sh.usedrange)       each cel in r2.cells          val = cel.value          if val <> ""              each col in r1.columns                  check = worksheetfunction.countif(col, val)                  if check > 0                     pos = worksheetfunction.match(val, col, 0)                      col.cells(pos, 1).copy                     cel.pastespecial paste:=xlpasteformats                  end if              next col          end if      next cel  end sub

run once copy formats. you'll need define 2 ranges: enter image description here

source range (a:b) , range paste (f:g)


Comments

Post a Comment

Popular posts from this blog

java - Run spring boot application error: Cannot instantiate interface org.springframework.context.ApplicationListener -

-
i have spring project , try make use spring boot , run @ embadded tomcat following : https://spring.io/guides/gs/rest-service/ this application //@configuration //@enableaspectjautoproxy @springbootapplication @componentscan(basepackages = "gux.prome") public class application { public static void main(string[] args) { springapplication.run(application.class, args); } } if use maven command: mvn spring-boot:run , project starts fine, need debug , run main method @ intelij, exception occurs: exception in thread "main" java.lang.illegalargumentexception: cannot instantiate interface org.springframework.context.applicationlistener : org.springframework.boot.logging.classpathloggingapplicationlistener @ org.springframework.boot.springapplication.createspringfactoriesinstances(springapplication.java:414) @ org.springframework.boot.springapplication.getspringfactoriesinstances(springapplication.java:394) @ org.springframework.bo...
Read more

reactjs - React router and this.props.children - how to pass state to this.props.children -

-
i'm using react-router first time , don't know how think in yet. here's how i'm loading components in nested routes. entry point .js reactdom.render( <router history={hashhistory} > <route path="/" component={app}> <route path="models" component={content}> </route> </router>, document.getelementbyid('app') ); app.js render: function() { return ( <div> <header /> {this.props.children} </div> ); } so child of app content component sent in. i'm using flux , app.js has state , listens changes, don't know how pass state down this.props.children. before using react-router app.js defines children explicitly, passing state natural don't see how now. using couple of react helper methods can add state, props , whatever else this.props.children render: function() { var children = react.ch...
Read more

Excel VBA "Microsoft Windows Common Controls 6.0 (SP6)" Location Changes -

-
i have excel workbook used generate quotations customers. there main page user inputs data, , there buttons generate various pdfs , send them customer. however, 1 user consistently getting error preventing generating , sending pdfs. i beleive "microsoft windows common controls 6.0 (sp6)". it's installed on users' computers. on mine, location "c:\windows\syswow64\mscomctl.ocx" on others "c:\windows\system32\mscomctl.ocx" the user experiencing issues on 32-bit machine, "mscomctl.ocx" file should in system32. have manually put in there, , pointed common controls reference in vba it. issue seems keep reverting looking in syswow64. since folder doesn't exist, can't find it, , can't produce pdfs. i thought perhaps issue user running older version of office (2007) there users on 2013 , 2016. thought perhaps mixture of 64-bit , 32-bit users. user gets sent workbook other users (as quotation process goes further, gets passed ...
Read more