TVStocks, MusicStocks and Life

Christian Pham won a World Series of Poker bracelet for a game he's never played before and entered by accident Antibody Jun 15, 13:41

Phil Hellmuth will choke a **** {nm} slipping jimmy Jun 15, 15:09

Jeremy Clarkson back at the BBC to do voice overs for his last episode of top gear, should air in a few weeks casey Jun 15, 09:46

Call the proverbial taxi for Top Gear it has run its course {nm} blaze223 Jun 15, 14:04

Good riddance to bad rubbish. {nm} hyperzeitgeist Jun 16, 05:14

Chris Evans (the non-captain america one) will host new Top Gear (no word on hammond and may yet) Early 2016 return casey Jun 16, 11:54

tho it does say "all new lineup". maybe the 3 are going to netflix casey Jun 16, 11:56

mr. robot (hacker show coming to usa network): episode 1: b+ casey Jun 15, 08:56

A new word call Trans-racial just invented {nm} mike255 Jun 15, 07:14

Game of Thrones - dayum (spoilers) Chateau_du_Mal_Voisin Jun 15, 04:52

HP: I, Robot Leg: These University Of Toronto Students Are Walking People With Disabilities Into A New Age. RotoHockeyYTD2013MainPort Jun 14, 17:18

continuing my question on my Summer Pick 5 spreadsheet tealfan Jun 14, 16:35

One option is to use multiple layers of conditional formatting, one for each movie yet to be released. So you'd have one rule that says if a RogerMore Jun 14, 17:36

Re-reading, for movies that have been released you would have to do this by column, which would involve more maintenance {nm} RogerMore Jun 14, 18:30

looks like you are trying to say if once is in a range of cells and I don't think you can do that using the range name - see my way inside JDolphin Jun 14, 18:40

That should have been under Tealfan's post. It's nice that some things end up easier than you think although harder to figure out at first {nm} JDolphin Jun 14, 18:41

Try this... socby19 Jun 14, 19:50

$M$7:$M$15 should be $M$9:$M$12 in my example. Also, applies to - top left to bottom right, not what I wrote. socby19 Jun 14, 19:54

thanks everyone...for some reason I couldn't get any of those to work...I wonder if having the 2 other rules there is messing me up... tealfan Jun 14, 21:54

That could be true. If more than 1 condition is met then you can have errors in formatting {nm} JDolphin Jun 15, 00:01

That looks like if one cell matches the entire range, instead of a part of it. {nm} socby19 Jun 15, 11:21

HP: Toronto Blue Jays Beat Boston 13-5, Win 11 Straight Games & Tie Franchise Win Streak Record. RotoHockeyYTD2013MainPort Jun 14, 16:30

DS: Soccer player ejected for the old double footed nutshot video included copadon Jun 12, 12:28

Doesn't surprise me there are so many red cards in MLS. Combination of worst tackling and worst refereeing in world football. {nm} hyperzeitgeist Jun 15, 03:21

The president of the Spokane chapter of the NAACP is a white woman pretending to be black Antibody Jun 12, 10:20

Wow - that was a weird story. And very sad {nm} JDolphin Jun 12, 10:58

This comic is becoming a reality fast... MattW Jun 12, 11:25

Liberal what are you going to do now. NAACP can't get rid of her face reverse race discrimination mike255 Jun 13, 16:38

They can if she committed fraud - mis-representing herself. LOL on you {nm} JDolphin Jun 13, 16:55

If she show up as white. NAACP. They would not hired because she is white. Is that discrimination {nm} mike255 Jun 14, 04:11

I'm replying to others reading the thread more than Mike, but the NCAAP's statement on the issue says the opposite. RogerMore Jun 14, 12:06

*NAACP {nm} RogerMore Jun 14, 12:07

Thanks Roger. I didn't know they include all groups or people discrimated against. {nm} JDolphin Jun 14, 18:51

Hulk Hogan vs. Gawker for $100M Antibody Jun 12, 10:05

NYT: Gawker’s Moment of Truth Antibody Jun 12, 14:33

V: ABC Accidentally (Or Not) Shows LeBron James' **** During NBA Finals. RotoHockeyYTD2013MainPort Jun 11, 23:39

was it big? CSBD Jun 12, 08:58

Roto was too busy watching the ball(s) {nm} RazorHawk Jun 12, 12:49

DS: Another Wrestler suddenly dies. Farewell Dusty Rhodes copadon Jun 11, 17:26

suddenly? he was 69 and huge {nm} slipping jimmy Jun 11, 20:08

SPORTSNET: Arizona Coyotes To File $200 Million Lawsuit Against The City Of Glendale. RotoHockeyYTD2013MainPort Jun 11, 15:46

HP: NHL Playoff Beards Should Be Razed, Says NBC Sports Boss Mark Lazarus. RotoHockeyYTD2013MainPort Jun 10, 18:10

CBC: The City Of Glendale, Arizona Is Considering Ending The Coyotes 15-Year, $225 Million Arena Lease Deal. RotoHockeyYTD2013MainPort Jun 10, 13:28

OWNER : 'The City of Glendale is displaying a complete lack of good faith, business acumen or an understanding of .....' RotoHockeyYTD2013MainPort Jun 10, 13:30

HELLO, Quebec City. NHL-Ready 18,500-Seat Arena Good-To-Go. RotoHockeyYTD2013MainPort Jun 10, 13:33

The East is already unbalanced with 2 extra teams. {nm} Antibody Jun 10, 15:38

The Most Incredible Heston Performance Since 'Ben-Hur' (1959). ESPN Link. RotoHockeyYTD2013MainPort Jun 10, 13:22

the Warriors are anything but. soft and getting manhandled by Lebron and the Tasmanian Della {nm} slipping jimmy Jun 10, 10:09

Two World Trade Center Revealed Antibody Jun 09, 17:31

Team Leadership duck1 Jun 09, 16:38