HOLLYWOOD STOCK EXCHANGE
THE ENTERTAINMENT MARKET
THE ENTERTAINMENT MARKET
$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.
The one pick is searched for within that list, and if it matches, the cell will change colors. Be careful about keeping the search range right. Accidentally including a blank cell might screw things up.
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
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