HSX Forum
TVStocks, MusicStocks and Life
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.
socby19
Jun 15, 11:21