TVStocks, MusicStocks and Life

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

anyone have a studio/space around LA they want to recommend? MrZero Jun 09, 16:24

P: Heisenberg Blue Ice Vodka now available Antibody Jun 09, 14:56

ESPN: Marshawn Lynch to play villain in Call of Duty: Black Ops III Antibody Jun 09, 11:35

like, literally as himself? {nm} slipping jimmy Jun 09, 12:20

Game is set in 2065 {nm} Antibody Jun 09, 14:57

THEWRAP: 'True Detective's Two (2) New Trailers See Colin Farrell, Vince Vaughn On The Edge (VIDEO). RotoHockeyYTD2013MainPort Jun 08, 23:29

TIME: This Graphic Shows How Two (2) Killers Escaped From New York's Largest Maximum-Security Prison. RotoHockeyYTD2013MainPort Jun 08, 20:42