HOLLYWOOD STOCK EXCHANGE
THE ENTERTAINMENT MARKET
THE ENTERTAINMENT MARKET
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...
When I say 2 other rules, I mean the rules for "in top 5" and "in right position".
continuing my question on my Summer Pick 5 spreadsheet Jun 14, 16:35
Re-reading, for movies that have been released you would have to do this by column, which would involve more maintenance {nm} Jun 14, 18:30
Try this... 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. 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... Jun 14, 21:54
That could be true. If more than 1 condition is met then you can have errors in formatting {nm} Jun 15, 00:01
That looks like if one cell matches the entire range, instead of a part of it. {nm} Jun 15, 11:21
