Conditional coloring in excel/pivot -


enter image description hereenter image description here

hi,

i trying set sheet, analyze , compare data within' pivot table (on left) data extracted manually data source (on right). assume table on right portfolio, , table on left stat overview of possible positions. column "s" given as:

=if(isna(match(o7,$b$7:$b$119,0)),"", "misa")

which lets me know if position on list on left, , column "a" given as:

=if(isna(match(b8,$o$4:$o$19,0)),"","1")

which lets me know whether asset within list held in portfolio.

so inquiry now, list on left have row colored, whenever asset held in portfolio, whenever there "1" in column "a", particular row should colored. have naturally played around conditional formatting, cant seem work. dont know if due fact pivot table vs. function in column "a"???

thanks, psb

please make sure range does't have '$'before range column , row numbers. '$' refers static values. in below screen, '$a4' indicates static column , dynamic row number. area on rule has applied dynamic, refers 'b4:g23' cells, whenever a4 =1 'b4:g4' highlight. a5=1 b5:g5...

enter image description here

ps:please note didn't apply rule on pivot table on normal range. same thing should hold pivot table also.


-

Comments

Post a Comment

Popular posts from this blog

loops - Spock: How to use test data with @Stepwise -

i used @stepwise automation. 8 test methods running sequentially complete process. 1 of methods take parameter , want pass different parameters method. but problem is: method takes first set of parameter, parameters processed and instead of proceeding next method, method takes next set of parameter. the source looks like: @stepwise class aosearchpagetest extends gebreportingspec { def "first_method"() { } def "second_method"() { when: @ particularpage then: process(area) process(coutntry) process(airport) process(dest_area) process(dest_coutntry) process(dest_airport) where: area << ["asia","europe"] country << ["japan","uk"] port << ["narita","london"] dest_area << ["asia","europe"] dest_country << ["k...
Read more

amazon web services - S3 Pre-signed POST validate file type? -

i know it's possible put limit on file size content-length-range header. possible validate file type? https://docs.aws.amazon.com/amazons3/latest/dev/httppostforms.html#policyconditions i see there content-type header, if set say, audio/mp3 allow mp3 files , return error if file not mp3? i found previous question answers mention validating file size: s3 direct upload restricting file size , type you can specify content-type @ post request. you can specify @ signature, post must done content-type: { "expiration": "2007-12-01t12:00:00.000z", "conditions": [ {"acl": "public-read" }, {"bucket": "johnsmith" }, {"content-type: "audio/mp3"} ] } creating html form (using aws signature version 4) edit: @ previous question found, checking content-type.
Read more