HOLLYWOOD STOCK EXCHANGE
THE ENTERTAINMENT MARKET
THE ENTERTAINMENT MARKET
Try this...
Select cell C2? (first AVNG2), Conditional formatting, manage rules, new rule, use a formula to determine...,
=SUM(IFERROR(SEARCH($M$7:$M$15, C2),0))
The M7 range would be where the list of misses are. C2 would be one pick.
select a format/fill color. OK. Applies to (select the range of top left pick to top right).
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